Reputation: 601
I have a table with some struct data types that I can access but would like it as columns.
select
consignment id,
user
from tbl
What I currently have
select
consignment id
, user.name
, user.email
, user.externalId
from tbl
What I want
I was able to get it by just calling every key of user
but on a table with hundreds of columns that would be terrible
Upvotes: 0
Views: 385