2 ms·
SQL is not an API. SQL is a language. It doesn't care how you came up with your statements. If you concatenate strings, that's your private business.
by vetinari 11y ago
SQL is not an API. SQL is a language.
It doesn't care how you came up with your statements. If you concatenate strings, that's your private business.
- Pxtl 11y agoSQL Servers have an API for a client language, and often they are extremely cumbersome for prepared statements. Not to mention that in many cases this "language" has no coherent way to say the obvious operation of "Escape all the control characters in this string". If you don't offer that, your language sucks.
- vetinari 11y agoThere are multiple APIs - from ODBC, ADODB to DB-API for Python or database-specific client libraries. They describe how to send SQL to the server, but they are not SQL and the SQL is not the API. Different layer.