secondly for where clause bindings/filters are they passed through to prisma and nothing brought back to server from db that should't I assume. This is particularly important for paging performance but for us also the security filters are embedded in db

I don't understand this question, can you please elaborate?

I was just trying to confirm Prisma does not load in more data than it needs to its local server, all filters/where clause are passed down to database

that's correct

thank you nilan for the replies