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]

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

> 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]

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]

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.