v0.3.3

What's New?

The Postgres dialect now prefers to use an ANY instead of an IN for filtering a collection for results.

Example:

Here is the normal SQL that would have previously been generated:

select id
from my_table
where id in (:1, :2, :3, ...)

Here is the updated pattern that is used now.

select id
from my_table
where id = ANY(:1)

This has the additional benefit of allowing us to avoid hitting the max bind parameters values of the engine.

This functionality can be disabled by setting the prefer_any_dialects repository variable to None or ().

What's Changed

• chore: include a services example in the README by @cofin in #56
• chore: fix examples in README.md by @sfermigier in #58
• chore: add sonarcloud to CI by @cofin in #57
• feat: prefer ANY over IN for postgres by @cofin in #60

New Contributors

• @sfermigier made their first contribution in #58

Full Changelog: v0.3.2...v0.3.3

v0.3.2

What's Changed

• feat: configurable autocommit handler factory function for Litestar plugin by @geeshta in #50
• fix: CollectionFilter returns all entries if values is empty by @cofin in #52
• fix: correct assertion for test case by @cofin in #55
• chore: updated README.md by @cofin in #53
• feat: add support for cockroachdb by @cofin in #48

New Contributors

• @geeshta made their first contribution in #50

Full Changelog: v0.3.1...v0.3.2

v0.3.1

What's Changed

• feat: consolidate litestar extension imports by @cofin in #49

Full Changelog: v0.3.0...v0.3.1

v0.3.0

What's Changed

• feat: service layer abstraction by @cofin in #45

Full Changelog: v0.2.2...v0.3.0

v0.2.2

What's Changed

• chore: add additional exclusions to sonar by @cofin in #37
• chore: address code duplication by @cofin in #38
• refactor: move serialization helpers into one place by @guacs in #40
• fix: use asyncio.run by @cofin in #42
• fix: remove extra filter imports by @cofin in #43
• chore: install all pre-commit hook types by default by @guacs in #41
• fix: remove extra all methods by @cofin in #44

Full Changelog: v0.2.1...v0.2.2

v0.2.1

What's Changed

• fix: correct reference to plugin for litestar by @cofin in #35
• docs: adds Sanic, Starlette, and FastAPI examples to README by @cofin in #36

Full Changelog: v0.2.0...v0.2.1

v0.2.0

What's New?

Full support for Microsoft SQL Server using pyodbc!

What's Changed

• feat: adds a fastapi and standalone example by @cofin in #33

Full Changelog: v0.1.1...v0.2.0

v0.1.1

What's Changed

This release includes a compatibility fix for Litestar's existing repository filters.

Full Changelog: v0.1.0...v0.1.1

v0.1.0

🎉 New Contributors 🎉

• @cofin made their first contribution in #1
• @JacobCoffee made their first contribution in #10
• @guacs made their first contribution in #18

What's New

• Full set of repository classes for working with SQLAlchemy models
• Plugins for FastAPI, Starlette, Sanic, and Litestar
• Alembic integration with Litestar
• Custom JSONB aliased datatypes that select the optimal datatype for each backend (Includes a custom Oracle JSON type as well)
• Full test suite for aiosqlite,sqlite, asyncpg, psycopg (sync and async), oracledb, duckdb, asyncmy, and spanner.