DSLやめてSQLでいいんじゃない？

const state = {
    price: { min: 10, max: 100 },
    article_name: { like: '%super%' }
};

-- baseQuery
SELECT
    a.article_id
    , a.article_name
    , a.price
FROM
    article AS a

SELECT
    a.article_id
    , a.article_name
    , a.price
FROM
    article AS a
WHERE
    a.price >= $1
    AND a.price <= $2
    AND a.article_name like $3

const state = { user_id: 42, name: 'Alice' };

WITH
    cte_users AS (
        SELECT
            id
            , name
        FROM
            users
        WHERE
            active = true
    )
SELECT
    *
FROM
    (
        SELECT
            id AS user_id
            , name AS user_name
        FROM
            cte_users
    ) AS sub

WITH
    cte_users AS (
        SELECT
            id
            , name
        FROM
            users
        WHERE
            active = true
            AND name = $1
    )
SELECT
    *
FROM
    (
        SELECT
            id AS user_id
            , name AS user_name
        FROM
            cte_users
        WHERE
            id = $2
    ) AS sub

const tableSchemas = [
    { name: 'users', columns: ['id', 'name'] }
];

SELECT id, age FROM users

Table 'users' contains undefined columns: age.

SELECT
    sale_id
    , sale_date
    , sale_total
    , detail_id
    , detail_quantity
    , detail_price
    , product_id
    , product_name
    , product_category
FROM
    sale_full_report

const mapping: JsonMapping = {
    rootName: "Sales",
    rootEntity: {
        id: "sale",
        name: "Sale",
        columns: {
            "id": "sale_id",
            "date": "sale_date",
            "total": "sale_total"
        }
    },
    nestedEntities: [
        {
            id: "saleDetails",
            name: "SaleDetails",
            parentId: "sale",
            propertyName: "details",
            relationshipType: "array", // Sale has multiple SaleDetails (downstream)
            columns: {
                "id": "detail_id",
                "quantity": "detail_quantity",
                "price": "detail_price"
            }
        },
        {
            id: "product",
            name: "Product",
            parentId: "saleDetails",
            propertyName: "product",
            relationshipType: "object", // Each SaleDetail has one Product (upstream)
            columns: {
                "id": "product_id",
                "name": "product_name",
                "category": "product_category"
            }
        }
    ],
    useJsonb: true
}; 

with "origin_query" as (select "sale_id" , "sale_date" , "sale_total" , "detail_id" , "detail_quantity" , "detail_price" , "product_id" , "product_name" , "product_category" from "sale_full_report") , "cte_object_depth_1" as (select * , case when "product_id" is null and "product_name" is null and "product_category" is null then null else jsonb_build_object('id', "product_id", 'name', "product_name", 'category', "product_category") end as "product_json" from "origin_query") , "cte_array_depth_1" as (select "product_json" , "sale_id" , "sale_date" , "sale_total" , "product_id" , "product_name" , "product_category" , jsonb_agg(jsonb_build_object('id', "detail_id", 'quantity', "detail_quantity", 'price', "detail_price", 'product', "product_json")) as "details" from "cte_object_depth_1" group by "product_json" , "sale_id" , "sale_date" , "sale_total" , "product_id" , "product_name" , "product_category") , "cte_root_sales" as (select jsonb_build_object('id', "sale_id", 'date', "sale_date", 'total', "sale_total", 'details', "details") as "Sales" from "cte_array_depth_1") select jsonb_agg("Sales") as "Sales_array" from "cte_root_sales"