Using SQL

Write typesafe sql with moor

Moor let’s you express a variety of queries in pure Dart. However, you don’t have to miss out on its features when you need more complex queries or simply prefer sql. Moor has a builtin sql parser and analyzer, so it can generate a typesafe API for sql statements you write. It can also warn about errors in your sql at build time.


Moor files

Learn everything about the new .moor files which can contain tables and queries

Experimental IDE

Get real-time feedback as you type sql

(Legacy) Custom queries

Let moor generate Dart from your SQL statements

Supported sqlite extensions

Information on json1 and fts5 support in the generator