Execute Query
AI-generatedSummary
Execute a custom SQL query on a specified SQLite database file and return the result rows as JSON.
Inputs
- File DB (required) — The filesystem path to the SQLite database file to query.
- Query (required) — The SQL query string to execute against the database.
Output shape
a list of JSON objects representing the rows returned by the query execution
The output contains one item per row returned by the SQLite query. Errors in execution will result in an error object if 'continueOnFail' is enabled, otherwise the node errors out.
Examples
Example 1: Select records
File DB set to /data/database.db; Query set to SELECT id, name FROM product WHERE id < 40; Operation set to Execute Query;