What is the context? You provide to little information to give any meaningful answer.
SQL dialects by definition are vendor dependent, by definition ORM's and Server products are vendor dependent. By definitio security issues are again inherent to those implementations.
Not sure if SQL drivers can return a structured object.
SQLite driver in both Python, Node and Kotlin; AFAIK, doesn't
Know whether the column, or generated column, is JSON
GROUP BY only returns the first column. It can be fixed with json_group_array or json_group_object, but the driver itself doesn't realize that the data is JSON, therefore will return string instead.
You post a number of "issues" and mention various databases. I'm not sure what the aim is of your question.
With everytihng, there are design limitations that much is a given. The question is what do you need as an end result and what are the tools that best fit that end result.
Choose a DB that fits, and work with the constraints of that database.
If you have something really concrete, then that may help much better to get to a solution
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
You're mentioning a lot of loosely related topics to SQL, what is it you actually want to ask here?
How well are SQL dialects supported in various domains? Especially for the sake of (1) conveniences without ORM, (2) security.
What is the context? You provide to little information to give any meaningful answer.
SQL dialects by definition are vendor dependent, by definition ORM's and Server products are vendor dependent. By definitio security issues are again inherent to those implementations.
The question is too broad
SQLite driver in both Python, Node and Kotlin; AFAIK, doesn't
GROUP BY
only returns the first column. It can be fixed with json_group_array or json_group_object, but the driver itself doesn't realize that the data is JSON, therefore will return string instead.I haven't tried enough PostGRES or MySQL native drivers in any of the languages I used, to tell all these aspects.
I have tried to create a SQLite ORM with this kind of sanitization as well. However, it doesn't fix the fact that, no matter what I do, identifiers are case-insensitive.
Normally, I would use a prepared statement, but
I know no way to make SQLite strongly typed, with native drivers, in TypeScript and Kotlin.
You post a number of "issues" and mention various databases. I'm not sure what the aim is of your question.
With everytihng, there are design limitations that much is a given. The question is what do you need as an end result and what are the tools that best fit that end result.
Choose a DB that fits, and work with the constraints of that database.
If you have something really concrete, then that may help much better to get to a solution