sqlQueryUpdateM method
Implementation
String sqlQueryUpdateM(int length, [String condition = '']) => '''
WITH $_nameTemp(
${columns.map(_columnsMapNames).join(', ')}
) AS (${_sqlQueryValues(length)})
UPDATE $name SET
${columns.map((e) => '''
${e.name} = (
SELECT ${e.name} FROM $_nameTemp
WHERE $name.${columnId.name} = $_nameTemp.${columnId.name}
)
''').join(', ')}
WHERE ${columnId.name} IN (SELECT ${columnId.name} FROM $name.${columnId.name});
''';