SQLite Forum

Which SQL standard does the latest SQLite support?
Login

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.