SQLTemplate insert = new SQLTemplate(
Artist.class,
"INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME, SMALLINT_UNSIGNED) VALUES (1, 'A', 33000)");
ObjectContext context = createDataContext();
context.performGenericQuery(insert);
SQLTemplate select = new SQLTemplate(Artist.class, "SELECT * FROM ARTIST");
select.setColumnNamesCapitalization(CapsStrategy.UPPER);
List<Artist> results = context.performQuery(select);