The problem was that SQL is a giant standard that nobody implements really correctly and it would blow up the HTML5 standard enormously. Also I don't think there is anything wrong with an async-only API that does potentially do disk access.
I'm fine with the async part, if there was a proper support for stuff like joins and sorts. Without this, you have to individually gather the single rows and do it in userspace code.
This is crazy enough, add async-ness to the whole mess and even with promises you end up with a shitload of spaghetti code.
Right now IndexedDB is a kids playground and nothing usable at all for any serious application.