In the examples below, the assumption is made that the display grid fields have matching field names and definitions to the database table fields.
Load all records at once
pjs.defineDisplay("display", "mydisplay.json");
var records = pjs.query("SELECT * FROM ORDERS");
display.grid1.replaceRecords(records);