[BUG]: db.query creates slow (?) queries in related queries

[gituser-rs]

Report hasn't been filed before.

• [X] I have verified that the bug I'm about to report hasn't been filed before.

What version of drizzle-orm are you using?

0.36.3

What version of drizzle-kit are you using?

0.28.1

Other packages

No response

Describe the Bug

I am new into SQL "Performance", but I guess SELECT * is not a good idea. I have checked for other reports, but found nothing related.

Here is the slice of query produced by drizzle:

 (SELECT json_array(`ads_user`.`support`) AS `data`
   FROM
     (SELECT * FROM `users` `ads_user` WHERE `ads_user`.`id` = `ads`.`userId` LIMIT 1) `ads_user`) `ads_user`

but SELECT ads_user.support works flawlessly

My relational query selects only support: