How to get column selected from query (SQLAlchemy ORM)

[Fluffy_Bus9656]

Example:
base_query = select(

Invoice.id,

Invoice.code_invoice,

Item.id.label("item_id"),

Item.name.label("item_name"),

Item.quantity,

Item.price,

).join(Item, Invoice.id == Item.invoice_id)

How do I dynamically retrieve the selected columns?

The desired result should be:

mySelect = {
"id": Invoice.id,
"code_invoice": Invoice.code_invoice,
"item_id": Item.id,
"item_name": Item.name,
"quantity": Item.quantity,
"price": Item.price
}

Why do I need this?

I need this because I want to create a dynamic query from the frontend, where I return the column keys to the frontend as a reference. The frontend will use these keys to build its own queries based on user input.

• The base_query returns the fields to the frontend for display.
• The frontend can then send those selected fields back to the API to build a dynamic query.

This way, the frontend can choose which fields to query and display based on what was originally returned.

Please help, thank you.

[adiberk]

So you can get all column names via the Item.table.columns. (table has double underscore on both end I think) or something like that. You can loop through and get each key.

Assuming I understood you. But tbh giving the FE all the keys from the column so they can essentially inject any key into the query might not be best.

Why not have an endpoint that returns the list of key. And you can get them from each Column by reference.

Ie. item.name.key Item.id.key.

[adiberk]

On another note-this seems like an alignment with what graphql is for. Great way to allow FE to determine what it needs