def _sql_expand_insert(self, spec, key_prefix = '', col_prefix = ''):
        col = list(spec)
        sql = '('
        sql += ', '.join(col_prefix + key for key in col)
        sql += ') VALUES ('
        sql += ', '.join('%(' + key_prefix + key + ')s' for key in col)
        sql += ')'
        params = {}
        for key in spec:
            params[key_prefix + key] = spec[key]

        return sql, params
.. versionadded:: 2014.7.0
dataset/ETHPy150Open SpriteLink/NIPAP/nipap/nipap/backend.py/Nipap._sql_expand_insert--crossover with--dataset/ETHPy150Open saltstack/salt/salt/modules/nftables.py/new_table