Use magic SQL syntax in nested queries

[wertania]

Hello. First thanks for Drizzle as a great product.

I would like to use the magic SQL query builder to have nested queries like that:

const result: any = await db.execute(sql`
	  WITH RECURSIVE product_hierarchy AS (		
		SELECT 
		  ${products.id}
		  ${products.name},
		  ${products.instanceId},
		  ${products.description},
		  ${products.parentId},
		  0 AS depth
		FROM ${products}
		WHERE id = ${startId}
  
		UNION ALL
  
		-- Recursive member: Fetch child products, incrementing the depth each time
		SELECT 
		  p.id, 
		  p.name, 
		  p.instance_id AS "instanceId", 
		  p.description, 
		  p.parent_id AS "parentId", 
		  ph.depth + 1 AS depth
		FROM data.products p
		INNER JOIN product_hierarchy ph ON p.parent_id = ph.id
		WHERE ph.depth < ${maxDepth}
	  )
	  SELECT * FROM product_hierarchy;
	`);

Is it possible to use the ${table.columnname}-Syntax for Aliases here?