An sql parser and static analyzer, written in pure Dart. At the moment, this library only targets the sqlite dialect and some advanced features aren't supported yet.
This library can parse most statements and perform type analysis for parameters and returned
columns. It supports joins,
group by, nested sql statements, updates and deletes, and more.
You can parse the abstract syntax tree of sqlite statements with
import 'package:sqlparser/sqlparser.dart'; final engine = SqlEngine(); final result = engine.parse(''' SELECT f.* FROM frameworks f INNER JOIN uses_language ul ON ul.framework = f.id INNER JOIN languages l ON l.id = ul.language WHERE l.name = 'Dart' ORDER BY f.name ASC, f.popularity DESC LIMIT 5 OFFSET 5 * 3 '''); // result.rootNode contains the select statement in tree form
Given information about all tables and a sql statement, this library can:
- Determine which result columns a query is going to have, including types and nullability
- Make an educated guess about what type the variables in the query should have (it's not really possible to be 100% accurate about this because sqlite is very flexible at types, but this library gets it mostly right)
- Issue basic warnings about queries that are syntactically valid but won't run (references unknown tables / columns, uses undefined functions, etc.)
To use the analyzer, first register all known tables via
SqlEngine.analyze(sql) gives you an
AnalysisContext which contains an annotated ast and information
about errors. The type of result columns and expressions can be inferred by using
AnalysisContext.typeOf(). Here's an example:
final id = TableColumn('id', const ResolvedType(type: BasicType.int)); final content = TableColumn('content', const ResolvedType(type: BasicType.text)); final demoTable = Table( name: 'demo', resolvedColumns: [id, content], ); final engine = SqlEngine()..registerTable(demoTable); final context = engine.analyze('SELECT id, d.content, *, 3 + 4 FROM demo AS d'); final select = context.root as SelectStatement; final resolvedColumns = select.resolvedColumns; resolvedColumns.map((c) => c.name)); // id, content, id, content, 3 + 4 resolvedColumns.map((c) => context.typeOf(c).type.type) // int, text, int, text, int, int
Moor, a persistence library for Dart apps, uses this package to generate type-safe methods from sql.
Most on this list is just not supported yet because I didn't found a use case for them yet. If you need them, just leave an issue and I'll try to implement them soon.
- For now,
INSERTstatements are not supported, but they will be soon.
- Compound select statements (
INTERSECT) are not supported yet
- Common table expressions are not supported
- Some advanced expressions, like
CASTs aren't supported yet.
If you run into parsing errors with what you think is valid sql, please create an issue.
- An sql parser and analyzer for Dart.