knex_dart 1.2.0
knex_dart: ^1.2.0 copied to clipboard
A Dart SQL query builder inspired by Knex.js. Use driver packages (knex_dart_postgres, knex_dart_mysql, knex_dart_sqlite) to connect to databases.
1.2.0 #
- Added
KnexQueryfor dialect-only SQL generation viaKnexQuery.forDialect(...)andKnexQuery.forClient(...). - Added schema parity APIs in
SchemaBuilderandSchemaCompiler, including:createTableLike,hasTable,hasColumn,renameView, view/materialized-view operations, schema operations, extension operations, andschema.raw(...). - Improved cross-dialect schema SQL generation for MSSQL and MySQL-family paths
(dialect-specific
dropTableIfExists,renameTable, and fulltext alter support). - Improved query compilation behavior for function-style subqueries, analytic
OVER(...)handling, and MSSQLLIMIT/OFFSETSQL generation. - Internal workspace refactor: core package moved under
packages/knex_dartwith no user-facing import path change.
1.1.0 #
- Added filesystem/config migration source support via
fromConfig(). - Added auto-registration of
JsonSchemaAdapterforfromSchema(...). - Added
Client.runInTransaction(...)hook and integrated migrator transaction path. - Added lateral joins API (
joinLateral,leftJoinLateral,crossJoinLateral). - Added and published supporting packages:
knex_dart_capabilities(0.1.0)knex_dart_lint(0.1.0)
- Documentation updates for migrations and optional dialect lint tooling.
1.0.0 #
- Initial stable release.
- SQL query builder core: SELECT, INSERT, UPDATE, DELETE.
- WHERE clauses, JOINs, aggregates, ORDER BY, GROUP BY, HAVING, LIMIT, OFFSET.
- Raw queries, CTEs, UNIONs, INTERSECTs, EXCEPTs, subqueries.
- JSON operators, full-text search, upserts (
onConflict().merge()). - Schema builder: createTable, alterTable, dropTable, foreign keys, indexes.
- Dialect-aware SQL generation (PostgreSQL
$1, MySQL/SQLite?). - 551+ tests passing with >85% coverage.
- Driver packages published separately:
knex_dart_postgres,knex_dart_mysql,knex_dart_sqlite.