Missing column alias for static union query used in infix

[vladimirkl]

Version: 3.11.0
Module: quill-jdbc-zio
Database: postgresql

Expected behavior

Static query with union should look the same including column aliases when used standalone or when used as a part of infix

Actual behavior

Column aliases are missing when query with union used in infix expression

Steps to reproduce the behavior

case class Person(name: String, age: Int)

val q1 = quote {
  (query[Person].map(p => Person("x", p.age)) union query[Person]).map(_.name)
}

val q2 = quote {
  infix"INSERT into names $q1".as[Insert[Person]]
}

q2 will print INSERT into names SELECT x1.name FROM ((SELECT 'x', p.age FROM person p) UNION (SELECT x.* FROM person x)) AS x1 - which is error in Postgres with message org.postgresql.util.PSQLException: ERROR: column x1.name does not exist. Running just q1 returns correct results.

https://scastie.scala-lang.org/vladimirkl/bkhEuyRiQqyFCW14oe0ipA/10

Workaround

add column alias manually using infix

@getquill/maintainers

[deusaquilus]

Thanks for this reproduction! This looks very fixable with Quats info.