dart_sql 0.0.7

Dart native js
Flutter Android iOS web

A declarative front end for SQL libries like moor:ffi that enables you to construct SQL queries using Dart syntax.

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()

Advantages #

  1. Exact knowledge of SQL syntax is unecessary, auto-competion will provide guidance
  2. No need to contruct cumbersome SQL strings
  3. Results in much clearner "pure-dart" code
  4. 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();
4
likes
80
pub points
63%
popularity

Publisher

aeyrium.com

A declarative front end for SQL libries like moor:ffi that enables you to construct SQL queries using Dart syntax.

Homepage

Documentation

API reference

License

MIT (LICENSE)

More

Packages that depend on dart_sql