Datacore API - A Few Query Bugs

[FindingJohnny]

I've been working with the Datacore API a bit and have found a few potential bugs with queries. They're all fairly similar so I'll list them all here.

Bugs:

Single vs Double Quote impacts validity of the query

This does not seem to be documented yet. Not sure if that's just a limitation of queries at this time, or if it's something we can fix so that you can use either quote style.
Example)

Querying properties with spaces

Querying properties with spaces is not well documented and does not work intuitively
Example)
https://github.com/user-attachments/assets/00a444da-fc82-461f-9dc9-52343a57d5c6

Querying properties using the $row function requires lower casing property names

I tested this a lot with @GamerGirlandCo and ultimately we found a work around, but the behavior seems buggy. Notably, using exists("Property With Space") would work fine, but as you'll see in the example video when working with $row you have to use a lowercased version of your property name for lookup, for example, temp1.query('@page and $row[lower("Property With Space")]) seems to work, but is a bit of an unusual user experience.
Example)
https://github.com/user-attachments/assets/a80ee827-4b06-4ff7-9cfa-f9ae79da077a

I'm happy to provide additional details on any or all of the above bugs if they don't make sense! 🙂