Popular BI Tools use a ‘select *’ query instead of ‘describe table’ query to get the list of columns. But in case of complex objects, the select * query just returns the first level of columns and not the inner columns.
Example data →
{
“name” :
“address” : {
“city” :
“state” :
“country” :
}
}
A ‘select *’ query will return only “name” and “address” columns whereas I need it to return the list of all nested columns too i.e. “name”, “Address”, “Address.city”, “address.state” and “address.country”.
A proposed solution would look like implementing a settings parameter we can toggle to return data with nested columns too for a ‘select *’ query.