Don't be afraid of using your chosen database's command ... on SQL syntax. I found the SQLite syntax diagrams to be especially helpful for that database. SQL statements can be written on a single line ...

Once you’ve installed SQLite, you’ll probably want to learn how to maneuver around the database’s command line interface (CLI). The SQLite CLI allows you to issue any valid SQL statements you like. To ...