Sign in
sqlite

Execute a single SQLite statement and return results

post/v1/sqlite/execute

Request body

Response

Result of executing an SQL statement.

columnsstring[] required

Names of columns.

Names of columns can be defined using the AS keyword in SQL:

SELECT author AS author, COUNT(*) AS count FROM books GROUP BY author
columnTypesstring[] required

Types of columns.

The types are currently shown for types declared in a SQL table. For column types of function calls, for example, an empty string is returned.

rowsAffectednumber required

Number of rows that were affected by an UPDATE, INSERT or DELETE operation.

This value is not specified for other SQL statements.

Changes

Changed in 1 of the 46 revisions of this API.121

  • eee85d2eafce121See the full diff
    • ▲

      removed subschema #1 subschema #2 from the statement/anyOf[subschema #2: ParameterizedQuery]/args request property anyOf list

      request-property-any-of-removed

    • ●

      the statement/anyOf[subschema #1]/ request property's maxLength was set to 100000

      request-property-max-length-set

    • ●

      the statement/anyOf[subschema #2: ParameterizedQuery]/sql request property's maxLength was set to 100000

      request-property-max-length-set

    • ○

      added subschema #1 subschema #2 to the statement/anyOf[subschema #2: ParameterizedQuery]/args request property anyOf list

      request-property-any-of-added