feat: support Backend.table((catalog, database, tablename))

[NickCrews]

Is your feature request related to a problem?

I frequently am not working in the default schema in my postgres database, and between different schemas in the same query. This means that I explicitly have to pass the schemas everywhere for a table. I have to pass the table name and schema around as two separate arguments as well, since when I call into ibis I do backend.table(table_name, database=schema).

What is the motivation behind your request?

Really, the table name and schema are one concept: the specification of a table location. I would like to be able to pass them around as one thing, and ibis use them interchangeably. See example usage below.

Describe the solution you'd like

current usage	still works after change?	new spelling
conn.table("t")	yes	conn.table("t") or conn.table(("t",))
conn.table("t", database="d"	??	conn.table(("d", "t"))
conn.table("t", database=("c", "d")	??	conn.table(("c", "d", "t"))

Now, I can just pass a round a single tuple that that fully specifies the location of a table.

I put the ?? for the "still works" column because I'm not sure if we should still support the old API, or if we should simplify things and remove it. I think I would be fine keeping the old API around if it doesn't make our implementation too complicated.

What version of ibis are you running?

main

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

NA

Code of Conduct

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