Generally, interactive clusters and jobs are better suited for data engineering and transformations as they support more than just SQL. However, if you are using pure SQL, then endpoints can be used for data transformations. All of the Spark SQL functionality is available in DSQL so you can create tables, insert/update data, and run multiple SQL statements within a single DSQL query.
Note that DSQL queries are mostly purposed for visualizations and data acquisition.
