Which SQL standard does the latest SQLite support?
(1) By anonymous on 2020-05-25 08:14:38 [link] [source]
Hi, I am interested in which SQL standard (I guess SQL:2016) does the latest SQLite support?
(2) By Stephan Beal (stephan) on 2020-05-25 08:31:15 in reply to 1 [source]
I am interested in which SQL standard (I guess SQL:2016) does the latest SQLite support?
sqlite does not specifically follow any specific standard. /forumpost/2ae92e0224 might be relevant for you, though.
(3) By anonymous on 2020-05-25 08:40:11 in reply to 2 [link] [source]
Thank you for the info, that would be helpful.
(4) By Simon Slavin (slavin) on 2020-05-26 23:09:31 in reply to 1 [link] [source]
We don't know. It would cost us over US$1,800 to buy a copy of that standard. And it's about to be obsolete, expected to be replaced with SQL:2019. So none of us want to pay that much to buy a copy.
We can tell you that SQLite is very compliant with SQL92. Do you have another SQL standard we can all read ? If we can read it, we can tell you things about it.