Snap has a unified querying system that allows you to query Databases, Tables, and Arrays all with the same set of blocks.
- In option filters, use the same syntax as the query block to build your option filter source.
- In database queries, the standard database functions of Create, Read, Update, and Delete (or CRUD) are performed with the Insert, Query, Update, and Delete blocks.
Details and Examples available
Click any of the headings below for more information on these blocks.
Query Block
The query block is used to retrieve rows from the data source (table, database, or array) which match the query.
Insert Block
The insert block can be used to insert a row.
Update Block
The update block can be used to update one or many existing rows.
Delete Block
Used to delete one or many rows that match an optional condition.