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