Compatibility#

Note

These table reflects the compatibility status of JupySQL >=0.7

DuckDB#

Full compatibility

  • Running queries with %%sql βœ…

  • CTEs with %%sql --save NAME βœ…

  • Plotting with %%sqlplot boxplot βœ…

  • Plotting with %%sqlplot histogram βœ…

  • Plotting with ggplot API βœ…

  • Profiling tables with %sqlcmd profile βœ…

  • Listing tables with %sqlcmd tables βœ…

  • Listing columns with %sqlcmd columns βœ…

  • Parametrized SQL queries via {{parameter}} βœ…

  • Interactive SQL queries via --interact βœ…

Snowflake#

We’re working on testing Snowflake, see here

  • Running queries with %%sql βœ…

  • CTEs with %%sql --save NAME βœ…

  • Plotting with %%sqlplot boxplot ❓

  • Plotting with %%sqlplot histogram ❓

  • Plotting with ggplot API ❓

  • Profiling tables with %sqlcmd profile ❓

  • Listing tables with %sqlcmd tables ❓

  • Listing columns with %sqlcmd columns ❓

  • Parametrized SQL queries via {{parameter}} βœ…

  • Interactive SQL queries via --interact βœ…

PostgreSQL#

Almost full compatibility

  • Running queries with %%sql βœ…

  • CTEs with %%sql --save NAME βœ…

  • Plotting with %%sqlplot boxplot βœ…

  • Plotting with %%sqlplot histogram βœ…

  • Plotting with ggplot API ❓

  • Profiling tables with %sqlcmd profile βœ…

  • Listing tables with %sqlcmd tables βœ…

  • Listing columns with %sqlcmd columns βœ…

  • Parametrized SQL queries via {{parameter}} βœ…

  • Interactive SQL queries via --interact βœ…

MariaDB / MySQL#

Almost full compatibility

  • Running queries with %%sql βœ…

  • CTEs with %%sql --save NAME βœ…

  • Plotting with %%sqlplot boxplot ❌

  • Plotting with %%sqlplot histogram βœ…

  • Plotting with ggplot API βœ… (partial support)

  • Profiling tables with %sqlcmd profile βœ…

  • Listing tables with %sqlcmd tables βœ…

  • Listing columns with %sqlcmd columns βœ…

  • Parametrized SQL queries via {{parameter}} βœ…

  • Interactive SQL queries via --interact βœ…

SQL Server#

  • Running queries with %%sql βœ…

  • CTEs with %%sql --save NAME βœ…

  • Plotting with %%sqlplot boxplot ❌

  • Plotting with %%sqlplot histogram ❌

  • Plotting with ggplot API ❌

  • Profiling tables with %sqlcmd profile βœ…

  • Listing tables with %sqlcmd tables βœ…

  • Listing columns with %sqlcmd columns βœ…

  • Parametrized SQL queries via {{parameter}} βœ…

  • Interactive SQL queries via --interact βœ…

Oracle Databases#

  • Running queries with %%sql βœ…

  • CTEs with %%sql --save NAME βœ…

  • Plotting with %%sqlplot boxplot ❌

  • Plotting with %%sqlplot histogram ❌

  • Plotting with ggplot API ❌

  • Profiling tables with %sqlcmd profile ❌

  • Listing tables with %sqlcmd tables βœ…

  • Listing columns with %sqlcmd columns βœ…

  • Parametrized SQL queries via {{parameter}} βœ…

  • Interactive SQL queries via --interact βœ…