Hello
I don't think it's deprecated, it's been just in slow development for many years. I believe it has all the necessary features and it is very easy to overcome whatever is missing with some custom templates. I've been using Querydsl since ~2012 or so and was extremely satisfied with it, one of my favourite libs ever, if not the one.
Don't expect to get the example right away, I added it just to show how easily you can "inject" any SQL into the rest of the API. That "stringTemplate" is a static utility method from com.querydsl.core.types.dsl.Expressions, which returns a StringTemplate, which can be placed anywhere StringExpression (or Expression<String>) is expected. Very flexible.
So yes, Querydsl is perhaps sleepy when it comes to development, but it's no problem to use it!
Cheers
Virgo