sql_to_ibis.py

import ibis

# Need to define a schema for each table in the SQL
catalog = {
    "employee": {"first_name": "string", "last_name": "string", "id": "int64"},
}

# SQL to translate
sql = "SELECT *, first_name as first FROM employee WHERE id < 5 ORDER BY id DESC"

# Parse SQL into in-memory Ibis expression
expr = ibis.parse_sql(sql, catalog)

# Decompile Ibis expression into Python code that will create that expression
code = ibis.decompile(expr, format=True)

print(code)