Select All from Sub-query

Hi,

I'm trying to figure out if it's possible for me to select all the columns from a sub-query.

I imagine if it were possible it'd be something like this:

const subQuery = db().select({ ... }).from(...).as("subquery");

const query = db()
    .select({ ...subQuery })
    .from(subQuery);

const subQuery = db().select({ ... }).from(...).as("subquery");

const query = db()
    .select({ ...subQuery })
    .from(subQuery);

Do I have to name all the columns?

Mario564•9/13/24, 4:21 PM

You can just do and that should get you every column defined in

JadenOP•9/15/24, 10:30 AM

@Mario564 My bad I didn't explain correctly what I'm trying to do. The problem I have with that solution is I want to add other columns to the select but get all the columns from the sub-query as well.

For instance:

JadenOP•9/15/24, 10:31 AM

I thought there might be a function like on the sub-query that would let me do this, but I can't seem to find an easy solution like that.

Mario564•9/16/24, 3:52 PM

Oh, I see what you mean now. We only have a function gets all table columns but not for subqueries or views.

copypaper•11/21/24, 9:14 PM

did you ever figure this out?