if (!sets || sets.length === 0) return ''

const clauses = []

for (const set of sets) {

let str = ''

const { table, column, value } = set

str = [table, column].filter(hasVal).map(info => identifierToSql(info)).join('.')

if (value) str = `${str} = ${exprToSQL(value)}`

clauses.push(str)

}

return clauses.join(', ')

const { table, set, where, orderby, limit, returning } = stmt

const clauses = [

'UPDATE',

tablesToSQL(table),

commonOptionConnector('SET', setToSQL, set),

commonOptionConnector('WHERE', exprToSQL, where),

orderOrPartitionByToSQL(orderby, 'order by'),

limitToSQL(limit),

returningToSQL(returning),

]

return clauses.filter(hasVal).join(' ')