bug: The function parse_sql fails when COUNT(*) is in the query

[jpohanka]

What happened?

I have the following toy example of an unbounded table:

tx_schema = {
    "date_id": "date",
    "store_id": "int32",
    "sold_amount": "double",
    "quantity": "double",
}

tx = ibis.table(
    name="tx",
    schema=tx_schema
)

When I want parse the query SELECT COUNT(*) AS row_count FROM tx, it throws a Keyword: '' error, as was already reported here: #8597 (comment)

What version of ibis are you using?

9.0.0

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

None.

Relevant log output

No response

Code of Conduct

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

[cpcloud]

@jpohanka Thanks for opening the issue!

Would you mind elaborating a bit on what you're using parse_sql for? Would love to hear about use cases in the wild.

[jpohanka]

@cpcloud Currently just testing the functionality, but I could imagine some migrations of BI reports using raw SQL to Ibis expressions.

[cpcloud]

Roger that! It's definitely got a lot of potential.

[jpohanka]

@cpcloud I agree, among many things, it could serve as a common abstraction layer for creating SQL expressions over several database systems.