I just released SQL Views module that provides some API for working with SQL Views. I am certain it would be useful for this project.