Package selection guidance compiled from public package information, community data, and project usage.
The sqlparser package is a Dart library designed to parse SQLite statements and perform static analysis on them. It enables developers to validate, inspect, and manipulate SQL queries programmatically without executing them. Ideal for tools that require deep understanding of SQL syntax, such as code generators, linters, or database migration utilities. The parser supports standard SQLite syntax and integrates well with drift, a popular SQLite ORM for Dart. It runs across all major platforms including Android, iOS, Web, macOS, Windows, and Linux.
Use cases
SQL query validation
Database migration tooling
Code generation from SQL
Static analysis of SQL scripts
Linting SQL in development workflows
Key features
SQLite syntax parsing
Static analysis capabilities
Cross-platform support
Integration with drift
Robust error reporting
Suitable for
Dart developers using SQLite
Tools requiring SQL inspection
Database schema management
Code generation pipelines
Development-time SQL validation
Considerations
Limited to SQLite syntax
Does not execute queries
Requires careful handling of complex SQL
Best used in build or dev tools
Not intended for runtime query execution
Original README
Original README snapshot from the linked source repository. Visit the repository for the latest content.
Drift
Core
Generator
Drift is a reactive persistence library for Flutter and Dart, built on top of
SQLite.
Drift is:
Flexible: Drift lets you write queries in both SQL and Dart,
providing fluent apis for both languages. You can filter and order results
or use joins to run queries on multiple tables. You can even use complex
SQL features like WITH and WINDOW clauses.
🔥 Feature rich: Drift has builtin support for transactions, schema
migrations, complex filters and expressions, batched updates and joins. We
even have a builtin IDE for SQL!
📦 Modular: Thanks to builtin support for daos and imports in SQL files, drift helps you keep your database code simple.
🛡️ Safe: Drift generates type-safe code based on your tables and queries. If you make a mistake in your queries, drift will find it at compile time and
provide helpful and descriptive lints.
⚡ Fast: Even though drift lets you write powerful queries, it can keep
up with the performance of key-value stores like shared preferences and Hive. Drift is the only major persistence library with builtin threading support, allowing you to run database code across isolates with zero additional effort.
Reactive: Turn any SQL query into an auto-updating stream! This includes complex queries across many tables.
⚙️ Cross-Platform support: Drift works on Android, iOS, macOS, Windows, Linux and the web. This template is a Flutter todo app that works on all platforms.
🗡️ Battle tested and production ready: Drift is stable and well tested with a wide range of unit and integration tests. It powers production Flutter apps.
This repository contains a number of packages making up the drift project, most
notably:
drift: The main runtime for drift, which provides most APIs.
drift_dev: The compiler for drift tables, databases and daos. It
also contains a fully-featured SQL IDE for the Dart analyzer.
sqlparser: A SQL parser and static analyzer, written in pure Dart. This package can be used without drift to perform analysis on SQL statements.
It's on pub at
.
We use melos to manage the different packages
in this repository.
You can install it with dart pub global activate melos. To activate it in this
repository, run dart pub get in this directory followed by melos bootstrap.