[meta]: Ibis expression and backend stability

[ncclementi]

Consolidating the #8996 and #8994 to make tracking the progress easier.

Ibis backend:

P1:

• feat(descheming): add catalog kwarg to table accessing methods #9000
• refactor: standardize use of keyword/positional-only arguments #9125 (PR: test(sigcheck): check function signature parity across backends #10008)
• feat: Ability to Distinguish between Table and Views #8382 (PR WIP: refactor(api): ddl accessor #9832)
• feat(parquet): figure out convention for multi-file parquet writing #8584 (feat(output-formats): add support for to_parquet_dir #9781)

P2 (nice to have)

• feat: add a to_json() output method #8866
• feat: allow creating temporary views in create_view #8727
• feat(settings): generalize and extend settings passthrough dictionary #9250
• feat: support passing pa.RecordBatch in con.insert/con.create_table #8133
• feat(read-apis): give the data source input arguments the same name  #9124

Ibis expression API:

P2 (nice to have)

• feat: allow specifying Optional and/or T | None in UDFs #7133
• bug: dt.highest_precedence([dt.uint64, dt.int32]) gives uint64, not int64 #7331
• refactor(ux): ensure that all known and knowable type errors raise UnsupportedBackendType instead of letting code pass through to the backend #8333
• refactor(api): rename to_* methods for type coercion to something else #9788