Skip to main content

@terascope/sql-builder / statement / SQLQueryParts

Interface: SQLQueryParts

Defined in: statement.ts:12

The parts of a SQL statement, before they are joined.

QueryAccess.restrictSQLParts returns this for callers that build their own statement, such as a frame that already has its relation. Use restrictSQLQuery to get a complete statement instead.

Properties​

PropertyTypeDescriptionDefined in
columnsstring[]The field paths select projects.statement.ts:20
excludes?string[]-statement.ts:23
includes?string[]The _source include/exclude lists Elasticsearch would receive, not column names.statement.ts:22
selectstringThe SELECT list, with the field restrictions already applied.statement.ts:14
sort?SQLSort[]The ordering the query itself asked for, if any.statement.ts:18
wherestringThe WHERE expression.statement.ts:16