I didn’t find any specification of the behavior in the Hibernate docs, but the between operator in HQL is translated to the between operator in SQL, which is inclusive.
So between in HQL is also inclusive, that is
A between 5 and 10
is equivalent to
A >= 5 and A <= 10