Custom Function to Transform Subqueries is missing types

So I am trying to write helper functions that are able to transform subqueries. The goal is to work around not having access either RPC's nor subqueries in select statements. A bit more context in this discussion: https://discord.com/channels/1043890932593987624/1085153354340114563/1116875363193192470
However using something like

function transformWithSubquery<T extends WithSubqueryWithSelection<ColumnsSelection, string>>(subquery: T) {
// do magic things

function transformWithSubquery<T extends WithSubqueryWithSelection<ColumnsSelection, string>>(subquery: T) {
// do magic things

doesn't seem to do the trick to actually work with subqueries as the types are hidden from what I can tell: https://github.com/drizzle-team/drizzle-orm/blob/1c9d63bd689e6b8b6a6abf3db1ec32ab6cf179ac/drizzle-orm/src/subquery.ts#L9
Would appreciate any insight, I've been stuck with this for the entire week now and it's starting to block a lot of other things on the team - thank you!

GitHub

TypeScript ORM that feels like writing SQL. Contribute to drizzle-team/drizzle-orm development by creating an account on GitHub.

function transformWithSubquery<T extends WithSubqueryWithSelection<ColumnsSelection, string>>(subquery: T) {
// do magic things

function transformWithSubquery<T extends WithSubqueryWithSelection<ColumnsSelection, string>>(subquery: T) {
// do magic things

GitHub

TypeScript ORM that feels like writing SQL. Contribute to drizzle-team/drizzle-orm development by creating an account on GitHub.