That a given SQL-like construct "works" on other database systems which accept something like SQL does not mean you should expect SQLite to accept it. To see what you can reasonably expect, consult [SQL As Understood By SQLite](https://sqlite.org/lang.html). Further, lose the square-bracket identifier delimiters. In SQL, double-quote characters are used for that purpose.