RethinkDB attempts to do something like this, but I agree, an efficient SQL version of this would be nice.