SQL Dataset
The sql dataset operator can be used to create a dataset from within a canvas, using data connectors that have already been configured. From the operator's left menu, select a data connector:
Next, write a SQL query and press the play button. The output dataframe can then be used like any other dataset: