So, I notice in the 4.0 realm, there was a proposal for a SQL like querying syntax based on JCR. It looks like it was possibly fully targetted for 4.1. Is this still the case?
No, this has been moved to 5.0. Se ISPN-221, feel free to watch/vote for it. If you're interested in helping out as well, let us know.