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
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