Here's a bit of information on it. SQL Query Tool.pdf

Thanks!

Is there somewhere I can get some examples of SQL queries? I'm trying to do a left join where I get all records in STOCK to table ORDERS. 

Under Setup>Usage>Reports>SQL Query you can see examples such as query VEN057. Sage University also offers a workshop for Using Sage X3 SQL Views to build queries off of that view. Here's a video on an example from our X3 Youtube channel: www.youtube.com/watch

Hi, John. As mentioned Sage University offers multiple trainings that may assist in your understanding of using queries in Sage X3 (Common Tools, Sage X3 - Requestors, and an advance Requestors course while working with Views). Since you are looking for something specific to SQL, the course that may present itself the most value to you would be the Expert workshop entitled "Using Sage X3 SQL Views to create Requesters/Queries".

Additionally, SQL not being native to Sage X3, you will find many resources on structuring SQL statements online. With regards to how data is organized in Sage X3 (the "Schemas") you find information that outlines the Data models in the various modules by going into the online help, clicking "Technical help", then clicking Data models and choosing the X3 Module/Data model you would like to view.

 Below is a link related to the Data model for the Sales Order in Sage X3that is defined in the systems online help.