For the willing: These are the links to the excerpts/descriptions of SQL Standards supported in MS T-SQL as "Mandatory Features" (36 altogether). Published by MS as OpenSpecs. There are optional features listed too, but posting just these for brevity. I'm not sure how to validate SQLite against these specs. There may be some ways to assess compliance. std|link ---|---- E021|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/0db6e905-b31b-4885-88af-7d40bcf0d7f4">E021, Character string types</a> E021-01|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/60d38a6a-e1a1-469f-a518-49d38bfa22b0">E021-01, CHARACTER data type (including all its spellings)</a> E021-02|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/d92be736-953d-4182-a965-24d851de4118">E021-02, CHARACTER VARYING data type (including all its spellings)</a> E021-04|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/fad25e57-c4d0-4212-87c0-eef62de88794">E021-04, CHARACTER_LENGTH function</a> E021-05|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/8ffe8683-f11c-46f0-b7ea-16c929941fcb">E021-05, OCTET_LENGTH function</a> E021-06|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/606ee469-66b6-4f0e-bc4b-1245be731590">E021-06, SUBSTRING function</a> E021-07|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/00f8f9a2-c113-4ad4-a168-9cba227bb9af">E021-07, Character concatenation</a> E021-09|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/b971e1ac-d9d7-489a-bd45-d36e4e399f25">E021-09, TRIM function</a> E021-11|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/caacf4bf-aac9-45c5-9353-be62f72b722b">E021-11, POSITION function</a> E051|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/8b0f9440-e15a-4b9e-87b3-50eab68a0e3d">E051, Basic query specification</a> E051-09|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/3ffccb68-6152-49d3-b645-aebf0b8404bb">E051-09, Rename columns in the FROM clause</a> E081|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/61b96204-8304-40b2-870c-50f8db2d320a">E081, Basic Privileges</a> E081-09|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/eaeb7d1c-4aa8-48b5-a062-2cf13bd1ae32">E081-09, USAGE privilege</a> E121|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/5428201c-9a75-47f4-a7cd-862fa57d4c97">E121, Basic cursor support</a> E121-17|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/2d656898-f12f-4022-85db-a7093043ff3f">E121-17, WITH HOLD cursors</a> E141|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/c4bcaeca-f365-4971-8e10-c3a18fe7fa5a">E141, Basic integrity constraints</a> E141-07|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/aae51297-04e5-4fab-b554-b892a76e68d9">E141-07, Column defaults</a> E152|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/5383babc-27c4-4f51-ae11-5c4df8f0d49c">E152, Basic SET TRANSACTION statement</a> E152-02|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/95491b55-df20-4ed4-9384-7fdc73d3b9f1">E152-02, SET TRANSACTION statement: READ ONLY and READ WRITE clauses</a> E171|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/c9cbe517-6f3a-4125-aecf-56371dc17523">E171, SQLSTATE support</a> E182|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/c00597fe-c1f6-4e80-b81a-97d4e0e62e44">E182, Module language</a> F031|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/95f719fc-9b07-4191-bb95-2622ade9b952">F031, Basic schema manipulation</a> F031-13|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/d77d7163-2693-4cbe-bf11-c1759cf748a3">F031-13, DROP TABLE statement: RESTRICT clause</a> F031-16|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/48bc9267-de9d-4fa0-bf05-9b8c86f0d317">F031-16, DROP VIEW statement: RESTRICT clause</a> F031-19|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/71576f91-d36e-403c-b7c8-07c4ec4d826e">F031-19, REVOKE statement: RESTRICT clause</a> F051|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/dbcfb961-63d4-4d68-85b8-5e199e9eea89">F051, Basic date and time</a> F051-03|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/f3a1cb3c-07fc-478f-a7e9-05f12528912a">F051-03, TIMESTAMP data type (including support of TIMESTAMP literal) with fractional seconds precision of at least 0 and 6</a> F051-06|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/343afb9c-00c8-4deb-95a3-2b3dc3ad5136">F051-06, CURRENT_DATE</a> F051-07|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/43c2f74d-dcc3-4c45-9348-754afab6663e">F051-07, LOCALTIME</a> F051-08|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/22ea4bcc-20a7-4b94-8369-35c8bc8f331d">F051-08, LOCALTIMESTAMP</a> F812|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/e5a811cb-12d5-4a91-9159-dee2d11016eb">F812, Basic flagging</a> S011|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/7962ac4f-e1c4-41c6-aa7c-6cc40f9fa7ce">S011, Distinct data types</a> T321|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/867cb4fa-dec6-4590-aafc-32d7320f339e">T321, Basic SQL-invoked routines</a> T321-01|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/e357c5a0-7c38-4c48-8e8a-0bf2f936d8d5">T321-01, User-defined functions with no overloading</a> T321-02|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/5b68179c-a3b0-47fd-ab4d-f1505d245e8c">T321-02, User-defined stored procedures with no overloading</a> T321-04|<a href="https://docs.microsoft.com/en-us/openspecs/sql_standards/ms-tsqliso02/b299d66a-d937-4de2-b2cf-c2bed4b24ade">T321-04, CALL statement</a>