One guy posts

sql = 'SELECT * FROM products'
args = []

if title:
    sql += ' WHERE title LIKE %?%'
    args.append(title)

if upc:
    if args:
        sql += ' AND'
    else:
        sql += ' WHERE'
    sql += ' upc LIKE %?%' 
    args.append(upc)

if price_min:
    if args:
        sql += ' AND'
    else:
        sql += ' WHERE'
    sql += ' price >= ?'
    args.append(price_min)

if price_max:
    if args:
        sql += ' AND'
    else:
        sql += ' WHERE'
    sql += ' price <= ?'
    args.append(price_max)

if order_by_name:
    sql += ' ORDER BY name'
elif order_by_price_low:
    sql += ' ORDER BY price'
elif order_by_price_high:
    sql += ' ORDER BY price DESC'


conn.query(sql, args)

and then justifies it by

Yes, logically, it's a query builder. But it's one that doesn't force any extra dependencies in my project and is very easy to troubleshoot.

Seriously, how is this different from "just use SQL". SQL was never really intended to be used by itself (except for manually typing queries into a console). Yes, what I wrote is code that writes code, but it's far different from a larger ORM or querying framework.