bug: dash in database name fails when parsing

[akanz1]

What happened?

When attempting to connect to a database (mssql in my case but likely irrelevant for the ticket) i get the following error.

Unable to connect to MSSQLConnector. Reason: Failed to parse 'my-dbname' into <class 'sqlglot.expressions.Table'>

Following the trace leads me to a parse_one which fails when the database variable holds a string including a dash.

I can quickfix this by doing the following but lack understanding and context if this might be a problem in other places.

in L.588 (L.641 on main), backends/sql/__init__.py

table = sg.parse_one(sg.to_identifier(database, quoted=True).sql(), into=sg.exp.Table, dialect=self.dialect)

What version of ibis are you using?

ibis 9.5.0
python 3.11

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

No response

Relevant log output

Code of Conduct

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

[cpcloud]

Thanks for the issue!

Can you show the exact code that reproduces the problem?

[cpcloud]

Hm, I think I figured out the reproducer, but the description here is a bit misleading.

It's not connecting that fails, it's calling list_tables.

[akanz1]

Thanks for the quick fix. Yes, it's the listing of tables in this case. Do you need any more information on this?