def _sql_expand_insert(self, spec, key_prefix = '<STR_LIT>', col_prefix = '<STR_LIT>'):
col = list(spec)<EOL>sql = '<STR_LIT:(>'<EOL>sql += '<STR_LIT:U+002CU+0020>'.join(col_prefix + key for key in col)<EOL>sql += '<STR_LIT>'<EOL>sql += '<STR_LIT:U+002CU+0020>'.join('<STR_LIT>' + key_prefix + key + '<STR_LIT>' for key in col)<EOL>sql += '<STR_LIT:)>'<EOL>params = {}<EOL>for key in spec:<EOL><INDENT>params[key_prefix + key] = spec[key]<EOL><DEDENT>return sql, params<EOL>
Expand a dict so it fits in a INSERT clause