I know there are similar requests for this but cannot understand why its not available.
The closest query that works:
(Key > PRODUCT5_ISSUE-1 AND Key < PRODUCT5_ISSUE-100) ORDER BY "date"
//works as long as the end range key actually exists. So you first have to find that number
Why not the ability to convert the keys to text than do a ~ for wildcards.
It is stupid not to have this.