The current query sources (v1) are inefficient and limited, as they require a query per property and cannot serve as primary sources. A new version (v2) is requested where a single root query defines properties from its selected columns.
### Is there an existing issue for this? - [X] 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 `SELECT`ed 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_