Composite primary key support

I have a Model which has composite primary key and is Rails 8 based When I use the paginate helper method

It fires queries like SELECT COUNT(DISTINCT ["id", "snapshot_date"]) FROM aggregate_portfolio_investment_snapshots INNER JOIN entities ON entities.deleted_at IS NULL AND entities.id = aggregate_portfolio_investment_snapshots.entity_id WHERE aggregate_portfolio_investment_snapshots.entity_id = 17

Which throws error Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '["id", "snapshot_date"]) FROM aggregate_portfolio_investment_snapshots