Jet Database Files

✨ New Features

• Generated model fields for DECIMAL / NUMERIC columns now use github.com/shopspring/decimal(issue).⚠️
• SQLite generator mapping for INTEGER and REAL columns; they are now generated as 64-bit Go types (issue).⚠️
• Added qrm.GlobalConfig.StrictFieldMapping to detect destination struct fields that are not mapped by query result columns (issue).
• Added qrm:"optional" support for fields that should be ignored by strict field mapping.
• Added support for scanning JSON columns into json.RawMessage.
• Exposed Serializer in dialect packages, allowing custom expression arguments to be assembled dynamically before calling CustomExpression (issue).

🐛 Bug Fixes

• Fixed IS_NOT_NULL() serialization so generated SQL is parenthesized correctly (issue).
• Fixed random CockroachDB comments appearing in generated model and SQL builder files (issue).
• Fixed SELECT_JSON handling so multiple returned NULL rows now produce an error.
• Fixed escaping for MySQL SELECT_JSON object keys.
• Fixed stmtcache.Tx.QueryContext to forward the provided context.
• Fixed strict scan validation so it runs only on the first row.

🧰 Maintenance

• Simplified internal expression and literal serialization code (PR)
• Split integration tests into a separate Go module.
• Split examples into a separate Go module.
• Removed pgtype from the main module dependency graph (issue).

⚠️ Breaking Changes

• Potentially breaking changes are marked with ⚠️ because they change generated model field types for some column types. If the previous behavior is preferred, users can restore it by customizing the generator.

Contributors

@k4n4ry @fernandesenzo @arthurvaverko @fesiqueira