While @Jochen Schwarze's answer is good, it did not answer the question of how to perform an SQL query on the data.
since i don't have SQLite installed i used QGIS' python interpreter to read the data from the sqlite(spatialite, since geometry existed) file and write it to csv.
sqlite_file = 'path/to/test.sqlite'
csvfile = 'path/to/test.csv'
conn = sqlite3.connect(sqlite_file)
c = conn.cursor()
data = c.cursor('select column1, column2, aswkt(GEOMETRY) geom from test;')
with open(csvfile, 'w', newline='', encoding='utf-8') as f:
writer = csv.writer(f)
this allowed me to read and convert the large file without having to add it to the workspace in QGIS.