Check out example codes for "sqlite json to table". It will help you in understanding the concepts better.

Code Example 1

# Insert values into a SQLite table with a JSON column using Python
# Loops array countries and inserts them one by one:
import json
for country in countries:
    c.execute("insert into countries values (?, ?)",
    	[country['id'], json.dumps(country)])
    conn.commit()
conn.close()

# Create a table using Python SQLite driver
import sqlite3
conn = sqlite3.connect('test.db')
c = conn.cursor()
c.execute("CREATE TABLE countries (id varchar(3), data json)")

Learn ReactJs, React Native from akashmittal.com