Social Network Query Language - Overview
SNQL is a query language that can be used to query the social network database. It supports a limited subset of SQL functionality and is used to implement most of the API functions that result in a database query.
Snql supports single table select statements, uncorrelated sub queries, most of the usual operators and a handful of functions.
SELECT, FROM, WHERE, ORDER BY and LIMIT are all supported.
The SNQL documentation lists all the tables and columns that may be queried, and the supported operators and functions.
ORDER BY can only sort by a single value, which may be a table column or an expression.
LIMIT clauses can take the following forms:
- LIMIT rows
- LIMIT offset, rows
- LIMIT rows OFFSET offset