docs: Unclear how to materialize a table or list materialized tables

[OlivierBinette]

Please describe the issue

Context:

I'm using Ibis to do data pre-processing, and then using the name of the materialized table in the database as the input to another pipeline.

Problem:

After spending some time working with Ibis and reading through the docs, I'm still unclear about the relationship between Ibis tables, the tables listed in con.tables, and the views and tables in my database.

Specifically, I think the documentation should clarify:

• When and how a lazy Ibis table becomes a view or a table in your backend database.
• How Ibis Tables get_name() function returns a value and how this name relates to the physical table name.
• How you can list materialized tables, or distinguish between unevaluated Ibis table expressions and database tables.
• How you can go from an Ibis Table to workinig directly with the underlying table reference (either through SQLAlchemy or your database' official Python client).

Code of Conduct

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