python function to execute sql query code example
Example 1: execut sql python
# connect database and create cursor here
import sqlite3
conn = sqlite3.connect('File.Name')
cur = conn.cursor()
# statement to be executed
cur.execute("""SELECT COL_NAME FROM TABLE_NAME LIMIT 5;""").fetchall()
Example 2: python list from sql
[item for t in self.sqlhlpr.select("SELECT DISTINCT item FROM table") for item in t]