Subquery using db.query and with statement

[riculum]

is it possible to perform a subquery using the db.query method in a database, where you can select products with their associated categories and also retrieve information about the sizes of articles within those categories, similar to the provided code snippet:

db.query.products.findFirst({
    with: {
        category: true,
        articles: {
            sizes: true //or something like this
        }
    },
});

It may be possible to use sql directly, just wondering if its possible with db.query