Inserting and Selecting New Records - One Query

Just found something very interesting in PostgreSQL, thanks to Claude.

I have a really nasty query on some huge tables. Here's the basic layout that we're concerned with:

class RawRoyaltyRecord < ApplicationRecord
  belongs_to :royalty_input_batch_partial
  belongs_to :track
  has_many :raw_royalty_records_sales
end

class RoyaltyInputBatchPartial < ApplicationRecord
  belongs_to :pro
  has_many :raw_royalty_records
end

class RawRoyaltyRecordsSale < ApplicationRecord
  belongs_to :raw_royalty_record
  belongs_to :sale
end

Don't worry about "Pro" and "Sale" - we just need their IDs.

The concept is this. We get spreadsheets in every quarter or …

basic class claude found postgresql query records something tables