Query Builder is the preferred method for selecting and importing data from a Structured Query Language (SQL) database without writing SQL statements. You can preview the data before you import the data into a data table. You can also share your queries so that other users can customize and run the queries.
Query Builder provides an alternative to writing your own queries usingthe 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.