I have this many to many relation in Postgres:

// migrations/2020_create_initial_tables.js



exports.up = function(knex) {

  return knex.schema

    .createTable('students', function(table) {

      table.increments('id').primary()

      table

        .string('email')

        .unique()

        .index()

      table.string('password')

    })

    .createTable('courses', function(table) {

      table.increments('id').primary()

      table.string('title').notNullable()

      table.text('description')

    })

    // A student can enroll many courses

    // A course can have many students

    .createTable('student_courses', function(table) {

      table.increments('id').primary()

      table

        .integer('student_id')

        .references('id')

        .inTable('students')

      table

        .integer('course_id')

        .references('id')

        .inTable('courses')

    })

    .catch(err => {

      console.error(err)

      throw err

    })

  // .finally(() => knex.destroy());

}



exports.down = function(knex) {

  return knex.schema

    .dropTableIfExists('students')

    .dropTableIfExists('courses')

    .dropTableIfExists('student_courses')

    .catch(err => {

      console.error(err)

      throw err

    })

}

I need to show a student's enrolled courses.
How do I query (all/an array of) courses by student.id?

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Stack: TypeScript, [email protected], Postgres@12-alpine, [email protected]