Since you are using raw SQL directly, then you have to retrieve the paged result yourself. Yes, easiest and more straightforward way is that you just receive the page values as parameters of your service operation and then build your SQL accordingly to retrieve the proper page.