Is it possible to execute select query with named parameters ?

[vladyslav2]

Lets say i want to do:

SELECT company FROM company WHERE approved = ${approved}

instead of
SELECT company FROM company WHERE approved = $1

thanks in advance

[elprans]

asyncpg uses native PostgreSQL syntax for parameters, unlike other database drivers, it does not do any sort of parameter interpolation. Hence only the $n syntax is supported.

A possible future enhancement to enable handling of named parameters is tracked in #9.

[bitmodeler]

To other people hitting this popular posted query; see:

https://gitlab.com/osfda/asyncpg_utility

A python class extension that supports named parameters in prepared statements.

(testing it today; should be stable by next week...)