How would you do CREATE TYPE foo_enum AS ENUM ('bar', 'baz') using HoneySQL? Is there a docs section that explains this?
There is no support for that. DDL is so irregular that it is hard to support in general and a lot of it is very database-specific. I have implemented some widely-used and fairly portable stuff but it's just too hard to implement everything -- especially when I don't use PostgreSQL (or MS SQL Server) so I'm not familiar with their syntax. I'm also not keen on accepting PRs for some of these features because that then places a future maintenance burden on me to support and potentially enhance a syntax I do not use or even know.
That's great, thank you for the clear answer. Totally understandable that you don't want to cover every edge case out there. I'll just use a string for this instead.
For some reason I thought in the back of my mind that HoneySQL provides an escape hatch of sorts for producing unusual queries that it doesn't have native support for.
Well, :raw, but then you're just back to strings 🙂