mapping data inside select function

Hi. Is there no other way to map data with nested object with select() function other than array.reduce? I would like to do it using the query, not JS as the amount of data can be big and take a long time. For now I am doing this by writing a big query using sql function in execute() but then I don't get real TS support for my types and I feel uncertain about possible bugs.