unnest is a fancy thing that isn't easily supported by SQLAlchemy right now.
there's a recipe at
https://github.com/sqlalchemy/sqlalchemy/issues/3566#issuecomment-441931333
which hopefully is still in working order, you'd have to work with that for now.
On Thu, Mar 12, 2020, at 8:31 PM, Shyam
Probably a simple question, but I am unable to translate the SQL to Query
API function calls.
I'm using PostgreSQL 11 and SQLAlchemy 1.3.
The raw SQL query I want to translate is this:
SELECT s.post_id, s.signature, count(a.query) AS score
FROM post_signature AS s, unnest(s.words, $1) AS