@benoit strange, this is working (no exception, ruby 3.2.2, ar 7.0.4.3), what is the minimal query which bug ? :
ActiveRecord::Base.connection.execute("with foo as (select 1 as
id), bar as (select 2 as id) select * from foo left join bar on foo.id = bar.id
").to_a