I have had good luck with https://github.com/mozilla/localForage as an API abstraction
Web SQL may be "deprecated," but it's unlikely to be dropped by Apple or Google, since so many mobile web apps depend on it. Even the mobile version of Gmail uses Web SQL.