Column type to constant type mapping

Not all database column types can be used with any constant type. Below tables tell you which combinations are supported.

PostgreSQL

Below table describes which PostgreSQL data types can be mapped to which constant types.

Constant	Possible data types
Boolean	boolean
String	uuid, text, character(n), character varying(n)
Integer	smallint, integer, bigint
Decimal	real, double precision, numeric, decimal
LocalDate	date
OffsetDateTime	timestamp with time zone