Support XML type in Postgresql

[digitalheir]

SQLDelight Version

2.0.2

SQLDelight Dialect

postgresql

Describe the Bug

CREATE TABLE IF NOT EXISTS my_table(xml XML)
insert:
INSERT INTO my_table(xml) VALUES('<root></root>'::XML);

It fails because SQLDelight does not know the XML type.

I've tried to fake it with

CREATE TABLE IF NOT EXISTS my_table(xml TEXT)
insert:
INSERT INTO my_table(xml) VALUES(CAST('<root></root>' AS XML));

But it still fails, because it doesn't know the XML type.

Stacktrace

No response