May I get a SQLite View on JSON format?

I am using Firefox SQLIte plugin and I have an option to export as CSV. Is it possible t开发者_如何转开发o do it on JSON?

Thank you

SQLite is a relational database and CSV is a natural textual representation of tabular data, as seen in the relational model. JSON is a textual represenation of an object. As such, it's not really suited for the representation of tabular data.

That said, you can use the CSV file produced from the SQLite database to generate JSON output.

I used sqlite studio to convert result to json. It is open source it does a good job! Although you might need to massage the json data a bit because it contains things like DDL, etc.