dart_sql

Description:

dart sql

dart_sql [Work In Progress] #
A declarative SQL front end for any SQL libriary like moor:ffi or sqflite that enables you to construct queries that look like ...
SQL.select().from('aircraft').where('tail_number').contains('N%').orderBy('model').asc.toString()
copied to clipboard
Advantages #

Exact knowledge of SQL syntax is unecessary, auto-competion will provide guidance
No need to contruct cumbersome SQL strings
Results in much clearner "pure-dart" code
Does not require Flutter, can be used for CLI and Server applications of Dart

Examples #
// SELECT * FROM aircraft
SQL.select().from('aircraft').toString();

// SELECT id, model, year FROM aircraft
SQL.select(['id', 'model', 'year']).from('aircraft').toString();

// INSERT INTO aircraft (model, year) VALUES ("SR22", "2014")
Map<String, dynamic> values = {"model": "SR22", "year": "2014"};
SQL.insert().into('aircraft').values(values).toString();

// DELETE FROM aircraft WHERE model = "SR22"'
SQL.delete().from('aircraft').where('model').eq("SR22").toString();
copied to clipboard