Hello! I am attempting to insert a new row into a table with a column defined as an array or UUIDs:

alter table medias add column "order" uuid[];

const order = [
  'BFAD6B0D-D3E6-4EB3-B3AB-108244A5DD7F'
]

Medias
  .query()
  .insert({
    order: lit(order.map(id => lit(id).castType('uuid'))).castArray()
  })

But the query is malformed and therefore does not execute:

INSERT INTO medias ("order")
VALUES (ARRAY [
  {"_value":"BFAD6B0D-D3E6-4EB3-B3AB-108244A5DD7F","_cast":"uuid","_toJson":false,"_toArray":false}
])

As can be seen, the query contains the JSON-stringified representation of the LiteralBuilder object and not something that the SQL syntax understands as a typecast.

If I skip casting the individual UUID strings and just cast the whole column into an array, then Postgres rejects the query because the column is of type uuid[] but I am attempting to insert the column as text[].

Is this a bug that the individual arrays are not properly cast as UUIDs or am I doing it wrong? 🤔

Thanks for your help!