Fluent Queries

Fluent queries allow you to run database queries in your server automation scripts using an SQL-like fluent interface. Intelligent code completion is available in the code editor both for the query inputs and for the result sets.

IMPORTANT!

Fluent queries can only be used in administrative context. See the Server SDK Reference Guide for information on how to temporarily change the transaction context.
Result sets include only the columns specified in the select statements. Lookup fields are not automatically expanded.
Data ownership is per organization.
Date and datetime values are not returned as strings. The wrapper for datetime values (JsDateTime) stores the date as UTC and provides utility methods for data manipulation.