Best Practice Write the SQL Automatically
We believe we built the business's best automated SQL join builder, which we named The Super Join Builder. Why make users write the SQL themselves when you can automate the process? Then, you allow the user to edit the SQL if they desire.
When you automate the SQL in a join builder, the user can easily change the column order in the select list. Users can instantly add an ORDER BY clause by dragging and dropping columns.
Most importantly, users can change the Join Hub to another system, and the join builder makes all the necessary changes in seconds.
Another reason to use an automated join builder is that these joins can be saved and executed on a scheduler and shared with others in the company.
But the icing is that you can use a WHERE clause on a foreign table that will eliminate rows before the data is moved, thus allowing tables with millions or billions of rows to work efficiently.
Check out the video below to see all of these best practices come into play.