for the "postgresql JSON function that wants to be in the FROM clause",
there is a way to do this with plain Core API but it generates a
subquery (that's here:
http://docs.sqlalchemy.org/en/rel_1_0/core/tutorial.html#functions ,
scroll down a little in that section), but also I've been
I'm stuck with the need to generate a query of the form like:
SELECT
a.id,
b.name,
jr.*
FROM
a, b outer join jsonb_populate_recordset(b.jrs) as jr(bid numeric, name
varchar) on (TRUE)
WHERE
a.id = b.a_id
First, it's not clear to me how to construct a dynamically defined RECORD
as 'jr(bid