Does anybody are conscious of a great website which provides a obvious reference around the SQL syntax based on HTML 5 client-side databases? I have looked about and can't appear to discover one.
This really is still a functional draft, but read much more about it here - http://dev.w3.org/html5/webdatabase/
You may be thinking about that as well - http://net.tutsplus.com/tutorials/html-css-techniques/quick-tip-learning-about-html5-local-storage/
rapid answer: http://sqlite.org/lang.html
the lengthy answer: the sql-syntax is not within the spec, since it is entirely based on sqlite, the db-engine utilized by both safari and chrome (the 2 browsers to aid webdb, with opera most likely following soon(ant) and ms and mozilla refusing to follow just because of the fact that such a spec would be too dependant of the evolution of an external component). so you'll most likely want to check out the sqlite sql dialect?