How do you properly perform a JOIN query in sqflite to combine genuinely related data stored across two or more separate distinct tables, such as combining orders together with their own individual customer information?

sqflite lets you execute genuinely raw SQL queries directly through its rawQuery method, which is genuinely necessary for more complex operations such as a JOIN query that combines rows from two or more genuinely separate related tables based on a shared matching column, such as properly joining an orders table together with a customers table based on a shared customer identifier, letting you retrieve genuinely combined, properly related data in just one single efficient query rather than needing to make several genuinely separate individual queries and then manually combine those separate results together completely yourself.

final results = await db.rawQuery('''
  SELECT orders.id, orders.total, customers.name
  FROM orders
  JOIN customers ON orders.customer_id = customers.id
''');