> My question is not about extending/improving SQLite but about having an > extra tool which helps to optimize the SQL written for SQLite. So SQLite > stays indeed lightweight and fast, but the SQL it is fed with is > automatically optimized.
Like I said, the optimizer tool is the programmer. In a lot of cases the sql in a program doesn't change so the best place to optimize it would be when the program is designed, not at query time. If anyone wrote a tool like that I'm sure it would be useful.