Select only a set to improve perfomance

I search to know if a user have an active subscription

@Query("select case when count(u) > 0 then true else false end from User u where u.id=:userId and  current_date < u.subscriptionEndDate")
boolean userActiveSubscription(Long userId);

subscriptionEndDate use a localdate

Probably user object is queried, is there a way to limit data retrived to return true or false

How many English words
do you know?
Test your English vocabulary size, and measure
how many words do you know
Online Test
Powered by Examplum