Query Builder is the preferred method for selecting and importing data from a SQL database without writing SQL statements. You can preview the data before importing it into a data table. Share your queries so that other users can customize and run the queries.
Query Builder provides an alternative to writing your own queries using the File > Database > Open Table feature. However, you can also start building a query in Query Builder and then add your own SQL statements.
Notes:
• Database table names that contain the characters $# -+/%()&|;? are not supported.
• The Value Order column property is not supported. Consider writing a script in the Post-Query Script window to sort the rows.