-
- use sqlite commands in Lepton files with shell commands
- download a CSV dataset using a shell command with curl
- read a CSV file in sqlite
-
- SELECT columns from a table
-
- COUNT to count the number of rows
- DISTINCT to only obtain distinct values
- LIMIT to obtain only a few rows
- ORDER BY to indicate sort order
-
- INSERT to add rows into a table
- UPDATE to modify records
- DELETE to remove rows
-
- CREATE to create a new table in a database
- DROP to remove a table
-
- LIKE for matching patterns
- BETWEEN (can be used for numbers, strings and dates)
-
-
-