I did the SQLite challenge in two languages and it's a very small subset of SQL. For instance it's sufficient if you're implementation of WHERE only accepts equals expressions with a column name on the left and a string value on the right.

But the great thing about their challenges is that they have you build some kind of sandbox that you can experiment on top of and try expand it with more features.