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 numeric, name varchar)' so 'jr' becomes a table name that could be referenced later on Then it's not clear to me how to construct a table-like object of a function call that one can reference in query() by it's name ('jr' in this case). Is it possible with SQLAlchemy? -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.