Add built-in cast function for SQL queries
Need built-in function for casting string datatypes to INT, NUMBER, DOUBLE, etc. in SQL queries as our data loader is converting the number to string during document creation. We have a requirement to filter on numeric values in our application.
This is on our roadmap and work has started on implementing this feature. We do not have an ETA on when this will be released but it should be within the next 2-3 months. Will update with an ETA when this feature gets closer to completion.
Thank you for your suggestion.
Nick Smith commented
Please add group by
Trutz-Sebastian Stephani commented
Provide CAST/CONVERT syntax for SQL queries to allow for numeric range queries and also for things like on the fly creation of data points for distance queries.