how to use query in database using pythhon code example

Example 1: python list from sql

[item for t in self.sqlhlpr.select("SELECT DISTINCT item FROM table") for item in t]

Example 2: python retrieves records after db select query

cursor.fetchall()