Generate SQL SELECT Statement

Source: R/sql_top_level.R

Generate SQL SELECT statement (key field values instead of where clause)

sqlForSelectByKey(tablename, fields = "*", keyValues = NULL)

Arguments

tablename

table name
fields

expression to select fields; field names are separated by comma and alias names may be used, just as SQL accepts, e.g.: "tstamp as myDateTime, parVal as myValue"; Default: "*"
keyValues

list of "key=value" pairs with the keys being valid field names of table