Big query has an interesting pricing and I do kinda like it. You pay for data in, while processing is basically free.

I don’t know the query they used, but limit can limit data scanned.

It’s been a long time since I used BQ, but I remember their query optimizer not being particularly advanced, so you had to be really careful where you put the limit.