Step - SQLite

SQLite module creates and read/writes an SQLite format database file.
We are currently using  https://github.com/genjidb/genji  so it's somewhat compatible with other sqlite versions.
See 

SQLite has some freedom around columns and types, please check docs and attached recipe.

job_sqlite_test.json
1KB, Uploaded 4 years ago

Settings:
Path: filename with path for sqlite database file
Create SQL : when creating a new db we need tables to be able to write data (not used with select statements) so here we can put a CREATE TABLE IF NOT EXISTS mytable statement.
It's a really good idea to use  Strict Tables  to return the same type.

SQL: SQLite syntax query to run

AsArray, Emptyok: as normal SQL statement