Low priority background query

I’m curious if it’s possible to either: set the priority, or minimize the impact, of a large amount of background queries.

There’s the main traffic to the site, and then there’s a low priority background job I don’t want to have interfere with page views.

When people talk about using sleep statements or server side cursors… I’m not even sure if that’ll work on the neon side.

what are ways to reduce SQL server load / let it serve other requests in peace?