Allowable JSON keys for SQL interaction objects

SQL interaction objects are java objects that allow CRUD operations on the database.

Key NameFindersUpdatersDeletersInsertersQuestionsCounters
namemandatorymandatorymandatorymandatorymandatorymandatory
uniqueoptional
(must be a boolean value of true or false, defaults to false)
invalidinvalidinvalidinvalidinvalid
selectClause
will create a select clause bean
optionaloptionaloptionaloptionalmandatory
must return a single result of type boolean
optional
must return a single result of type integer
selectFields
only if required by the select clause
optionaloptionaloptionaloptionalinvalidinvalid
whereClauseoptionaloptionaloptionaloptionaloptionaloptional
whereFields
only if required by the where clause
optionaloptionaloptionaloptionaloptionaloptional
insertClauseinvalidinvalidinvalidoptionalinvalidinvalid
valuesClauseinvalidinvalidinvalidoptional
only if there is no select clause
invalidinvalid
valueFieldsinvalidinvalidinvalidoptional
only if there is no select clause and there is a values clause
invalidinvalid
setClauseinvalidmandatoryinvalidinvalidinvalidinvalid
setFieldsinvalidoptional
only if required by the set clause
invalidinvalidinvalidinvalid
orderByoptionalinvalidinvalidinvalidinvalidinvalid