bug: mssql insert throw table not found error if specify schema and database

[ruiyang2015]

What happened?

for following example:

c = ibis.mssql.connect(...)
df = pd.DataFrame.from_dict({'val': [1, 2, 3]})
c.insert('t', df, database='db.mydbo')

getting an exception like this:

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/Users/ruiyang/Go/src/github.com/ascend-io/ascend-core/.venv/lib/python3.11/site-packages/ibis/backends/sql/__init__.py", line 407, in insert
    query = self._build_insert_from_table(
            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/ruiyang/Go/src/github.com/ascend-io/ascend-core/.venv/lib/python3.11/site-packages/ibis/backends/sql/__init__.py", line 422, in _build_insert_from_table
    target_cols = self.get_schema(target).keys()
                  ^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/ruiyang/Go/src/github.com/ascend-io/ascend-core/.venv/lib/python3.11/site-packages/ibis/backends/mssql/__init__.py", line 281, in get_schema
    raise com.IbisError(f"Table not found: {fqn}")
ibis.common.exceptions.IbisError: Table not found: t

What version of ibis are you using?

9.5.0

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

mssql

Relevant log output

No response

Code of Conduct

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

[ruiyang2015]

the exception is from the base class of sql backend, and it seems a bug of getting the query schema,
the get_schema is invoked with only table name, without passing through the database and catalog arguments from the insert call to it.

[ruiyang2015]

looks like there is already a draft pr to address this issue:
#9821
but it seems no further progress on it, can anyone prioritize it?