When using the in-memory implementation, Index syntax will parse but there will be no indexes on the tables. The backend is not implemented.

This may cause weird ordering or other issues where utilizing an index would produce different results than the raw query.