[Feature]: Query Sources v2

[bleonard]

Is there an existing issue for this?

• I have searched the existing issues

Is your feature request related to a problem? Please describe.

The original iteration of query sources was a query per property; however, these can not be used as a primary source because they need a WHERE clause and they lead to inefficiencies.

Describe the solution you'd like.

A new query source should have a query at the root. The SELECTed columns would be properties.
These should produce the data that is written to the Records and then sync'd as they are now.
This source would be able to be used as a primary source or incorporate current property values and be a secondary source.
It should be optional to do things incrementally as this is not always available.
In the ideal case, it would also be able to be used in the Config UI and sample profiles.

Describe an alternate solution.

No response

Additional context

No response