SQLite queries in Python can be implemented with sqlite3 and pandas. The advantage of using pandas for query execution is that the return value is a pandas DataFrame. Handling a pandas DataFrame might be handy.

Below result implements and executes a simple SELECT query in Pythin using pandas and sqlite3.

import pandas as pd
import sqlite3

# connect to database
con = sqlite3.connect('sales.db')

# write query
query = '''
SELECT *
FROM clients
'''

# execute query in Python using pandas (obtaining results in DataFrame format)
df = pd.read_sql_query(query, conn)