[HELP]: I'm trying to re-create a CTE-insert in drizzle, having some difficulties

      const query = sql<OrderProduct[]>`
        with cart_products as (
          select * from cart_product where cart_id = ${cartId}
        )
        insert into order_product (order_id, cart_product_id)
        select ${orderId}, id from cart_products
        returning 
          id,
          order_id as "orderId",
          cart_product_id as "cartProductId";
      `;

      // Don't know why, but type-inferece is not working here, need to use
      // "as" to cast the type
      const data = (await this.db.db.execute(query)) as OrderProduct[];

      const query = sql<OrderProduct[]>`
        with cart_products as (
          select * from cart_product where cart_id = ${cartId}
        )
        insert into order_product (order_id, cart_product_id)
        select ${orderId}, id from cart_products
        returning 
          id,
          order_id as "orderId",
          cart_product_id as "cartProductId";
      `;

      // Don't know why, but type-inferece is not working here, need to use
      // "as" to cast the type
      const data = (await this.db.db.execute(query)) as OrderProduct[];

const cartProducts = db.$with('cart_products').as(db.select().from(cartProduct).where(eq(cartProduct.cartId, cartId)));

const insrt = await db.insert(orderProduct).values({ orderId, cartProductId});

const selected = await db.with(cartProducts).select({ orderId: orderProduct.orderId }).from(cartProducts).returning(...);

const cartProducts = db.$with('cart_products').as(db.select().from(cartProduct).where(eq(cartProduct.cartId, cartId)));

const insrt = await db.insert(orderProduct).values({ orderId, cartProductId});

const selected = await db.with(cartProducts).select({ orderId: orderProduct.orderId }).from(cartProducts).returning(...);

const cartProducts = db.$with('cart_products').as(db.select().from(cartProduct).where(eq(cartProduct.cartId, cartId)));
const insert = await db
  .insert(orderProduct)
  .values(
    db.with(cartProducts)
    .select(
      {
        id: orderProduct.id
        orderId: orderProduct.orderId
      })
    .from(cartProducts)
  )
  .returning(...);

const cartProducts = db.$with('cart_products').as(db.select().from(cartProduct).where(eq(cartProduct.cartId, cartId)));
const insert = await db
  .insert(orderProduct)
  .values(
    db.with(cartProducts)
    .select(
      {
        id: orderProduct.id
        orderId: orderProduct.orderId
      })
    .from(cartProducts)
  )
  .returning(...);

const cartProducts = db.$with('cart_products').as(db.select().from(cartProduct).where(eq(cartProduct.cartId, cartId)));
const insert = await db
  .insert(orderProduct)
  .values(
    db.with(cartProducts)
    .select(
      {
        id: orderProduct.id
        orderId: orderProduct.orderId
      })
    .from(cartProducts)
  )
  .returning(...);

const cartProducts = db.$with('cart_products').as(db.select().from(cartProduct).where(eq(cartProduct.cartId, cartId)));
const insert = await db
  .insert(orderProduct)
  .values(
    db.with(cartProducts)
    .select(
      {
        id: orderProduct.id
        orderId: orderProduct.orderId
      })
    .from(cartProducts)
  )
  .returning(...);

with cart_products as (
          select * from cart_product where cart_id = ${cartId}
        )
        insert into order_product (order_id, cart_product_id)
        select ${orderId}, id from cart_products
        returning 
          id,
          order_id as "orderId",
          cart_product_id as "cartProductId";

with cart_products as (
          select * from cart_product where cart_id = ${cartId}
        )
        insert into order_product (order_id, cart_product_id)
        select ${orderId}, id from cart_products
        returning 
          id,
          order_id as "orderId",
          cart_product_id as "cartProductId";

select
*
from table,
(select ...) as col_1,
(select ...) as col_2,
where col_1 is not null;

select
*
from table,
(select ...) as col_1,
(select ...) as col_2,
where col_1 is not null;

select()
.from(`${table},
(select ...) as col_1,
(select ...) as col_2`)
.where(sql`col_1 is not null`);

select()
.from(`${table},
(select ...) as col_1,
(select ...) as col_2`)
.where(sql`col_1 is not null`);

select((col1, col2) => ({
  id: col2.id
  name: col1.name
}))
.from(
  select().from(), // col 1
  select().from()  // col 2
).
where((col1, col2) => {
// do something with col1 and col2
})

// or maybe
const c1 = select().from()
const c2 = select().from()

select({
  id: c2.id
  name: c1.name
})
.from(
  c1,
  c2
).
where(() => {
// do something with c1 and c2
})

select((col1, col2) => ({
  id: col2.id
  name: col1.name
}))
.from(
  select().from(), // col 1
  select().from()  // col 2
).
where((col1, col2) => {
// do something with col1 and col2
})

// or maybe
const c1 = select().from()
const c2 = select().from()

select({
  id: c2.id
  name: c1.name
})
.from(
  c1,
  c2
).
where(() => {
// do something with c1 and c2
})