results = db.engine.execute(text(sql))

SELECT email, AVG(assignment_1_obj_grade.grade) as assignment1obj, assignment_1_sub_grade.grade as assignment1sub, AVG(assignment_2_obj_grade.grade) as assignment2obj, assignment_2_sub_grade.grade as assignment2sub, AVG(assignment_3_obj_grade.grade) as assignment3obj, assignment_3_sub_grade.grade as assignment3sub, AVG(assignment_4_obj_grade.grade) as assignment4obj, assignment_4_sub_grade.grade as assignment4sub, AVG(assignment_5_obj_grade.grade) as assignment5obj, assignment_5_sub_grade.grade as assignment5sub, AVG(assignment_6_obj_grade.grade) as assignment6obj, assignment_6_sub_grade.grade as assignment6sub, AVG(assignment_7_obj_grade.grade) as assignment7obj, assignment_7_sub_grade.grade as assignment7sub, AVG(assignment_8_obj_grade.grade) as assignment8obj, assignment_8_sub_grade.grade as assignment8sub, AVG(assignment_9_obj_grade.grade) as assignment9obj, assignment_9_sub_grade.grade as assignment9sub FROM enrollment LEFT JOIN objective_grade AS assignment_1_obj_grade ON (enrollment.email = assignment_1_obj_grade.student_email and assignment_1_obj_grade.assignment_id = 1 and assignment_1_obj_grade.is_most_recent = 1) LEFT JOIN subjective_grade AS assignment_1_sub_grade ON (enrollment.email = assignment_1_sub_grade.student_email and assignment_1_sub_grade.assignment_id = 1) LEFT JOIN objective_grade AS assignment_2_obj_grade ON (enrollment.email = assignment_2_obj_grade.student_email and assignment_2_obj_grade.assignment_id = 2 and assignment_2_obj_grade.is_most_recent = 1) LEFT JOIN subjective_grade AS assignment_2_sub_grade ON (enrollment.email = assignment_2_sub_grade.student_email and assignment_2_sub_grade.assignment_id = 2) LEFT JOIN objective_grade AS assignment_3_obj_grade ON (enrollment.email = assignment_3_obj_grade.student_email and assignment_3_obj_grade.assignment_id = 3 and assignment_3_obj_grade.is_most_recent = 1) LEFT JOIN subjective_grade AS assignment_3_sub_grade ON (enrollment.email = assignment_3_sub_grade.student_email and assignment_3_sub_grade.assignment_id = 3) LEFT JOIN objective_grade AS assignment_4_obj_grade ON (enrollment.email = assignment_4_obj_grade.student_email and assignment_4_obj_grade.assignment_id = 4 and assignment_4_obj_grade.is_most_recent = 1) LEFT JOIN subjective_grade AS assignment_4_sub_grade ON (enrollment.email = assignment_4_sub_grade.student_email and assignment_4_sub_grade.assignment_id = 4) LEFT JOIN objective_grade AS assignment_5_obj_grade ON (enrollment.email = assignment_5_obj_grade.student_email and assignment_5_obj_grade.assignment_id = 5 and assignment_5_obj_grade.is_most_recent = 1) LEFT JOIN subjective_grade AS assignment_5_sub_grade ON (enrollment.email = assignment_5_sub_grade.student_email and assignment_5_sub_grade.assignment_id = 5) LEFT JOIN objective_grade AS assignment_6_obj_grade ON (enrollment.email = assignment_6_obj_grade.student_email and assignment_6_obj_grade.assignment_id = 6 and assignment_6_obj_grade.is_most_recent = 1) LEFT JOIN subjective_grade AS assignment_6_sub_grade ON (enrollment.email = assignment_6_sub_grade.student_email and assignment_6_sub_grade.assignment_id = 6) LEFT JOIN objective_grade AS assignment_7_obj_grade ON (enrollment.email = assignment_7_obj_grade.student_email and assignment_7_obj_grade.assignment_id = 7 and assignment_7_obj_grade.is_most_recent = 1) LEFT JOIN subjective_grade AS assignment_7_sub_grade ON (enrollment.email = assignment_7_sub_grade.student_email and assignment_7_sub_grade.assignment_id = 7) LEFT JOIN objective_grade AS assignment_8_obj_grade ON (enrollment.email = assignment_8_obj_grade.student_email and assignment_8_obj_grade.assignment_id = 8 and assignment_8_obj_grade.is_most_recent = 1) LEFT JOIN subjective_grade AS assignment_8_sub_grade ON (enrollment.email = assignment_8_sub_grade.student_email and assignment_8_sub_grade.assignment_id = 8) LEFT JOIN objective_grade AS assignment_9_obj_grade ON (enrollment.email = assignment_9_obj_grade.student_email and assignment_9_obj_grade.assignment_id = 9 and assignment_9_obj_grade.is_most_recent = 1) LEFT JOIN subjective_grade AS assignment_9_sub_grade ON (enrollment.email = assignment_9_sub_grade.student_email and assignment_9_sub_grade.assignment_id = 9) GROUP BY email ORDER BY assignment2obj LIMIT 10 OFFSET 0;

import sqlite3
conn = sqlite3.connect('mydatabase.db')
c = conn.cursor()
results = c.execute(sql)