SQL自定义参数的实现方法

def fill_params(sql, params={}):
    if not params:
        assert '${' not in sql
        return sql
    for n, v in params.items():
        n = n.replace('_', '\\_')
        pattern = re.compile(rf'\${{{n}}}')
        sql = re.sub(pattern, str(v), sql)
    assert '${' not in sql
    return sql

填充sql方法~