A SQLite command. INSERT is special cased to handle AUTO INCREMENT columns. The fromSqliteCommand function will take an SqliteCommandSyntax and convert it into the correct SqliteSyntax.

The syntax for SQLite is stored as a Builder along with a list of data that hasn't been serialized yet.

The first argument is a function that receives a builder for SQLData and returns the concrete syntax to embed into the query. For queries sent to the backend, this is simply a function that returns "?". Thus, the syntax sent to the backend includes proper placeholders. The list of data is sent to the SQLite library for proper escaping.

When the syntax is being serialized for display (for use in beam migrate for example), the data builder attempts to properly format and escape the data. This returns syntax suitable for inclusion in scripts. In this case, the value list is ignored.

SQLite SELECT syntax

SQLite INSERT syntax. This doesn't directly wrap SqliteSyntax because we need to do some processing on INSERT statements to deal with AUTO INCREMENT columns. Use formatSqliteInsert to turn SqliteInsertSyntax into SqliteSyntax.

SQLite UPDATE syntax

SQLite DELETE syntax

Convert a SqliteCommandSyntax into a renderable SqliteSyntax

Render a SqliteSyntax as a lazy ByteString, for purposes of displaying to a user. Embedded SQLData is directly embedded into the concrete syntax, with a best effort made to escape strings.

The SQLite group_concat function. Joins the value in each row of the first argument, using the second argument as a delimiter. See sqliteGroupConcatOver if you want to provide explicit quantification.

The SQLite group_concat function. Joins the value in each row of the first argument using ','. See sqliteGroupConcat if you want to change the delimiter. Choosing a custom delimiter and quantification isn't allowed by SQLite.