As it looks like based on the documentation about SqlDelight, there is no support for the Point
Datatype.
Given that I'd rather not want to match the database to a library, let's assume for the sake of this example that I have an existing database with the Point
datatype. How can I write insert statements?
Unfortunately, I cannot even write the following in apartment.sq
file:
CREATE TABLE apartment(
id BIGSERIAL NOT NULL,
location POINT
);
Error:
<type name real> expected, got 'POINT'
I haven't tested adapters, but to my understanding if I declare this table with a different underlying data type, wrong statements would be generated anyway when trying to insert a point.