bug: sql parsing cannot handle TPC-H

[EpsilonPrime]

What happened?

ibis.expr.sql.parse_sql raises an exception for any reasonable SQL query

What version of ibis are you using?

9.3.0

What backend(s) are you using, if any?

None

Relevant log output

import ibis
import pyarrow.parquet as pq
from ibis.expr.sql import parse_sql
from ibis_substrait.compiler.core import SubstraitCompiler

def main():
    sql = "SELECT COUNT(*) FROM customer"
    table_schemas: dict[str, ibis.Schema] = {}

    r = pq.read_table(
        '/$HOME/projects/data/tpch/parquet/customer.parquet')
    table_schemas['customer'] = ibis.Schema.from_pyarrow(r.schema)

    expr = parse_sql(sql, catalog=table_schemas)
    compiler = SubstraitCompiler()
    return compiler.compile(expr)


if __name__ == "__main__":
    main()


ibis-framework            9.3.0
ibis-substrait            4.0.1
pyarrow                   17.0.0                   
pyarrow-hotfix            0.6

Code of Conduct

• [X] I agree to follow this project's Code of Conduct