typed_sql

• Support CREATE INDEX DDLs through @Index annotations.

• Support CREATE INDEX DDLs through @Index annotations.

• Fixed code generator bug that affected onConflict clauses with non-default naming.

• Fixed code generator bug that affected onConflict clauses with non-default naming.

• Allow nullable boolean in .where(...) clauses.
• Allow nullable boolean in JOIN .on(...) conditions.
• Support for combining Expr<bool?> expressions.
• .equals / .equalsValue return Expr<bool?>, following SQL semantics.
• Breaking change:
  • removed .notEquals and .notEqualsValue methods from nullable expressions

• Allow nullable boolean in .where(...) clauses.
• Allow nullable boolean in JOIN .on(...) conditions.
• Support for combining Expr<bool?> expressions.
• .equals / .equalsValue return Expr<bool?>, following SQL semantics.
• Breaking change:
  • removed .notEquals and .notEqualsValue methods from nullable expressions

• Introduce .insertValue which automatically wraps with toExpr(), but is
  unfortunately unable to insert default value for nullable fields that
  have a default value other than NULL.
• Introduce .insert(..).onConflict(..).update(..).where(..).returning(..)
  enabling upsert-style inserts.
• Introduce .insertValuesMapped(..) for bulk-inserts.
• Improve performance by using string literals for JSON path expressions in
  generated SQL.
• Introduce @SqlOverride annotation for overriding:
  • Column type,
  • Column name,
  • Default naming convention,
  • Collation, or,
  • Default value expression.

• Introduce .insertValue which automatically wraps with toExpr(), but is unfortunately unable to insert default value for nullable fields that have a default value other than NULL.
• Introduce .insert(..).onConflict(..).update(..).where(..).returning(..) enabling upsert-style inserts.
• Introduce .insertValuesMapped(..) for bulk-inserts.
• Improve performance by using string literals for JSON path expressions in generated SQL.
• Introduce @SqlOverride annotation for overriding:
  • Column type,
  • Column name,
  • Default naming convention,
  • Collation, or,
  • Default value expression.

• Fix constraint name generation for FOREIGN KEY DDLs.

• Fix constraint name generation for FOREIGN KEY DDLs.

• Set PRAGMA foreign_keys = ON; on all sqlite connections.
• Use classes in generated files.
• Add constraint name to FOREIGN KEY DDLs.
• Support ON DELETE and ON UPDATE actions (e.g. CASCADE).

• Set PRAGMA foreign_keys = ON; on all sqlite connections.
• Use classes in generated files.
• Add constraint name to FOREIGN KEY DDLs.
• Support ON DELETE and ON UPDATE actions (e.g. CASCADE).

0.1.7

• Removed the debug use of package:test from mysql adapter.

• Removed the debug use of package:test from mysql adapter.

• Upgraded dependencies (incl. package:analyzer).

• Added TransactionAbortedException.toString() to render the reason when printing an exception.
• Fix postgres support for DateTime.utc(0), which must be encoded as 'BC' suffixed date-time.
• Escaping table names in queries.
• Fix .update / .delete for tables with composite primary keys.

• Support for composite foreign keys using the @ForeignKey annotation.
• Extension methods for joining table using foreign keys.

• Fixed build issues where it's unable to resolve CustomDataType.

Initial version.