SQL: add release notes for refactor (GH6292)

This should (finally) close #6292.

WIP for now, but comments welcome. Have to add to release.rst.

@jreback Should I mark the new sql as experimental? (and if so, where should I do this?)