feat: support Synapase Serverless SQL pool

[ruiyang2015]

Is your feature request related to a problem?

Synapse Serverless/Dedicated are both compatible with MS SQL server dialect, but the default behave of Synapse Serveless is tht DBO schema is read only.

c = ibis.mssql.connect(...)
df = pd.DataFrame.from_dict({'v': ['v1', 'v2']})
c.create_table('team', df, database='myschema')

this will getting an error from _register_in_memory_tables, where a temp in memory table is created in the dbo schema even though i tried to specify the database parameter for a different schema.

What is the motivation behind your request?

to support broader ms sql server like server.

Describe the solution you'd like

fix the _register_in_memory_tables code, so it register the in memory temp table in the same schema as the target table.

What version of ibis are you running?

9.1.0

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

synapse serverless

Code of Conduct

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