Sunday, 20 December 2020

How to get metadata of an SQL query?

I know how to read metadata for existing DB table using SQL Alchemy:

meta = MetaData(bind=engine)
meta.reflect(schema="schema_name", views=True, resolve_fks=False)
res = meta.tables["table_name"]

Question:

How can I get metadata or column types for an SQL query (select * from tab1 join tab2 on tab1.id = tab2.id)?



from How to get metadata of an SQL query?

No comments:

Post a Comment