Retrieving Kudos In A Timeframe

Hi!

I am trying to get a list of the Kudos that were given in the last hour for example, across the board. Not the count but the actual user who received each of the kudos in that time frame.

Looking at the docs and playing around I see this:

\"kudos\" must be constrained by \"message.id, image.id, message.author.id or user.id\". in: SELECT message FROM kudos"

So this doesn't seem to let me constrain by time which means I would have to basically query for every kudo received and loop through ALL of these every time in order to get the ones that happened in the last hour?

Surely there has to be another more efficient way?