Investigate the use of opensource libraries to allow full local execution and potentially cross-platform compatibility

[jrampono]

Feature 1: Enable notebooks to be generated targeting local execution engine like duckdb or sqllite and then swapped to target Fabric remote environment easily

Feature 2: Enable other execution engines to be targeted such as Databricks or Snowflake

**Notes
Potentially libraries shown below. Note Ibis uses both sqlframe and sqlglot under the hood. Similarly sqlframe uses sqlglot under the hood. Thus sqlglot is likely to be the easiest place to start as it provides sql dialect translation only. Note we may need to deal with ddl carefully as none of these appear to deal with it well

• https://github.com/tobymao/sqlglot - DDL support seems hit and miss
• https://sqlframe.readthedocs.io/ - Looks to not support spark.sql() operations that do not return anything
• https://ibis-project.org/ - Likely to have same ddl support issues as SQLglot