Support `IN` queries - Githubissues

mcfunley / pugsql

A HugSQL-inspired database library for Python

https://pugsql.org

Apache License 2.0

681 stars 22 forks source link

Support `IN` queries #14

Closed mcfunley closed 5 years ago

mcfunley commented 5 years ago

AFAICT there's no way to do this currently. It should work,

Ideally without parsing the query.
But if we have to parse the query, we can use the hugsql syntax for this.

If it turns out there is already a way, it should be documented.

mcfunley commented 5 years ago

This works in 0.1.13 and later--I figured out how to enable this when just passing tuples and lists as parameter values to get this behavior, which is nicer than I was hoping for

https://github.com/mcfunley/pugsql/commit/ebfb684181dc4a3997e99b8153762e55803a955c