In Rails you can make this 3 queries. One to retrieve the board, one to get all the report IDs associated with the board and a third to get all the reports with the associated report IDs.

An example in Rails would look like:

  board = Board.includes(:reports).find(board_id)