v0.28.1

What's Changed

• feat: better handling of empty SQL files by @cofin in #216

Full Changelog: v0.28.0...v0.28.1

v0.28.0

What's Changed

• fix: Refactor ADK store SQL table creation methods to be asynchronous by @cofin in #144
• feat: FastAPI and Starlette extensions by @cofin in #147
• feat: Flask extension by @cofin in #148
• docs: cleanup examples by @cofin in #151
• fix: session key consistency by @cofin in #152
• feat: Google ADK store signature update by @cofin in #153
• feat: add Arrow type system foundation for select_to_arrow() by @cofin in #154
• feat: add select_to_arrow() to base driver classes by @cofin in #155
• feat: add native Arrow support for ADBC, DuckDB, and BigQuery adapters by @cofin in #156
• feat: add Arrow support to PostgreSQL adapters by @cofin in #157
• feat: add Arrow support to SQLite and MySQL adapters by @cofin in #158
• feat: add native Arrow support for Oracle adapter by @cofin in #159
• docs: code highlight fixed on light theme by @euri10 in #161
• docs: complete Apache Arrow integration documentation by @cofin in #164
• feat: add NumPy array serialization support by @cofin in #165

New Contributors

• @euri10 made their first contribution in #161

Full Changelog: v0.27.0...v0.28.0

v0.27.0

What's Changed

• feat: add TypedDict support to schema_type and to_schema by @cofin in #91
• feat: improve schema conversion and caching optimizations by @cofin in #92
• feat: enhance database error handling with granular exceptions by @cofin in #93
• feat: add logging filter to suppress erroneous sqlglot fallback warnings by @cofin in #94
• feat!: remove Python 3.9 support by @cofin in #95
• feat!: refactor Litestar extension - remove wrapper classes, unify handlers by @cofin in #96
• feat: refactor storage submodule for improved readability and maintainability by @cofin in #99
• feat(litestar): implements a session backend by @cofin in #98
• feat: add initial documentation for SQLSpec by @cofin in #100
• feat(adk): Implement Google ADK Session Backend by @cofin in #101
• fix: overhaul docs build process by @cofin in #103
• feat: add optional numpy serialization support by @cofin in #104
• fix: add TypedDict support to driver method overloads by @cofin in #105
• feat(result): add schema_type parameter to SQLResult helper methods by @cofin in #106
• docs: remove unbased performance claims and marketing language by @cofin in #107
• docs: redesign adapters page by @cofin in #108
• feat(oracle): enable automatic numpy integration by @cofin in #109
• feat: Add agent guides and fix schema typing issues by @cofin in #111
• feat: Improve driver consistency by @cofin in #110
• fix(migrations): eliminate duplicate SQL file loading by @cofin in #119
• feat(migrations): use git config for default migration author by @cofin in #120
• feat(migrations): improve messaging for empty migration folder by @cofin in #121
• feat(cli): rename make-migrations to create-migration by @cofin in #122
• chore: improved llm agent guides by @cofin in #123
• fix(core): use qualified names for SQLSpecError to fix IDE autocomplete by @cofin in #124
• chore(docs): update agent guides and clean up documentation by @cofin in #126
• refactor(types): remove redundant total=False from TypedDict definitions by @cofin in #127
• feat(cli): add shell completion documentation and tests by @cofin in #125
• refactor(builder): refactor sqlspec.builder for improved consolidation by @cofin in #131
• fix(cli): convert Path to string in show-config command by @cofin in #136
• fix: honor --dry-run flag in migration commands (fixes #133) by @cofin in #135
• feat: implement hybrid timestamp/sequence based migration versioning by @cofin in #128
• feat: add transactional migrations support (#132) by @cofin in #137
• chore(specs): updated spec driven workflow by @cofin in #138
• feat(oracle): implicitly named columns create lower-case dictionary keys by @cofin in #139
• fix(oracle): automatic CLOB hydration for msgspec integration by @cofin in #140
• fix(pgvector): improve pgvector registration logging by @cofin in #141
• chore: add doc string for init file by @iyad-f in #142
• docs: fix the litestar integration example by @iyad-f in #143

Full Changelog: v0.26.0...v0.27.0

v0.26.0

What's Changed

• refactor: refactor cursor exit by @iyad-f in #79
• feat: enhance sync_tools and migration infrastructure by @cofin in #81
• feat: add data dictionary support for database metadata by @cofin in #82
• chore: remove unnecessary .gitkeep file creation by @iyad-f in #84
• feat: enhanced serialization & type conversation process by @cofin in #86
• feat: async migrations and callable config support by @cofin in #87
• feat: add FOR UPDATE locking support to query builder by @cofin in #88
• fix: add bind_key parameter support to all adapter configurations by @cofin in #89

Full Changelog: v0.25.0...v0.26.0

v0.25.0

What's Changed

• feat: remove private variable usage and improve public API by @cofin in #76
• fix: correctly handle duplicate usage of the same bind parameter by @cofin in #77
• feat: support numpy decoder by @cofin in #78

Full Changelog: v0.24.1...v0.25.0

v0.24.1

What's Changed

• fix: correctly detect RETURNING clauses by @cofin in #75

Full Changelog: v0.24.0...v0.24.1

v0.24.0

What's Changed

• feat: correctly merge parameter names & adds or builder support by @cofin in #73
• feat: refactor builder code to reduce duplication by @cofin in #74

Full Changelog: v0.23.0...v0.24.0

v0.23.0

What's Changed

• feat: add support for lateral joins in the builder by @cofin in #72

Full Changelog: v0.22.0...v0.23.0

v0.22.0

What's Changed

• fix: get_next in sync tools properly raises StopIteration by @cofin in #70
• feat: update storage backend and add tests by @cofin in #71

Full Changelog: v0.21.1...v0.22.0

v0.21.1

What's Changed

• fix: to_schema detect msgspec rename configurations by @cofin in #69

Full Changelog: v0.21.0...v0.21.1