When working with the SQLite command line shell, you have the option of having your query results formatted as string literals.
You can do this by switching to “quote” mode. When you do this, strings are enclosed in single-quotes and internal single-quotes are escaped by doubling. Also, blobs are displayed in hexadecimal blob literal notation, numbers are displayed as ASCII text, and NULL values are shown as “NULL”.
If you need to format your results with double quotes, consider using csv
mode.