I partitioned my main table which has over 12,000,000 records and archived the records before a certain date. My question is, without changing the queries that were written before partitioning this table, if the desired record is not in the partitioned table, will it be automatically searched for that record in the archive table or not?

Because the structure of the created queries is based on the ORM model, it is very difficult to change our queries.