Querying Records with Properties Split Across Multiple Containers

Hello,

We are considering storing a relational database table with more than 100 columns as Records.
Since the maximum number of properties per container is 100, we need to define a single table across two or more containers.

In this case, I would like to know how to write a query that allows us to freely filter records that have properties defined across multiple containers.
Our goal is to query the Records data in a way similar to executing SQL on the original RDB table with over 100 columns.

Based on my testing, the behavior was as follows, which is not what I intended:

• When using only properties from container A in the filter or sort: only records of properties from container A are retrieved.
• When using properties from both container A and container B in the filter or sort: an empty JSONL is returned.

If this cannot be resolved with a single query, I would appreciate advice on what kind of post-processing could help achieve the desired result.