Default - SQL that will be used when not using individual operations like get, insert, update, etc.
Get - SQL used to determine how data will be retrieved from the database.
SELECT id, year, make, model FROM auto_info WHERE year = {:2} AND make = {:3} AND model = {:4}
Set - SQL used to determine how data will be set in Jira, not the database.
Insert - SQL used to determine how data will be inserted into the database.
INSERT INTO auto_info(id, year, make, model) VALUES ({:1}, {:2}, {:3}, {:4})
Update - SQL used to determine how data will be updated in the database.
UPDATE auto_info SET year = {:2}, make = {:3}, model = {:4} WHERE id = {:1}
Delete - SQL used to determine how data will be deleted from the database.
DELETE FROM auto_info WHERE id = {:1}
Search - SQL used to determine how data will be searched in the database.
SELECT id, year, make, model FROM auto_info WHERE year = {:2} AND make = {:3} AND model = {:4}
Seq - I don’t know what the hell this is