Queries are created using the custom string interpolation method
Basic Parameter Interpolation
Parameterized queries are created by using interpolated parameters:
Relate uses JDBC’s
PreparedStatement to correctly escape inputs.
Sequences of values are inserted as comma-separated lists.
Sequences of sequences of values are inserted as comma-separated tuples.
Types must be visible at compile time and correspond to parameterizable types.
The following does not compile, as Relate cannot parameterize
Tuples should be used instead.
For more dynamic queries, SQL statements can be composed with interpolation