In a @Select annotation (and in the others as well) it is possible to write the SQL statement as an array of strings. This is quite handy if one has a multi string SQL and can't use Java 15 with its ...

/* Another strategy to add a surrogate key to an existing table is to concatenate existing columns with the CONCAT() function. The table is populated with 10 rows of completely fictional data.