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
β