feat: add a method for table existence check

[asiunov]

Is your feature request related to a problem?

If I understand correctly, the best way to check table existence is by running table_name in list_tables(like=table_name), but this may be inefficient if the database contains a lot of tables, and may be incorrect if table_name contains regex chars.

By the way, probably another feature request is to push the filter to server: list_tables does filtering on client side (at least for BQ, Snowflake, DuckDB), which is inefficient if there are a lot of tables.

What is the motivation behind your request?

No response

Describe the solution you'd like

A new method Backend.table_exists.

Also, maybe change Backend.list_tables(like) to server-side filtering.

What version of ibis are you running?

9.0.0

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

DuckDB, Snowflake, BigQuery

Code of Conduct

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