Fluent API and data return type in extensions

[franky47]

Question

I'm maintaining an extension that performs field-level encryption, by walking the tree of returned data to look for fields to decrypt.

Recently, I had a bug report indicating that it doesn't work with the Fluent API.

The heart of the problem is that the query passed to the extension asks for a type of data, but the data coming back after awaiting the downstream query doesn't correspond to that expected type (see 47ng/prisma-field-encryption#80 (comment)).

There doesn't seem to be a way for the extension to know that the downstream query will change the returned data type, as it seems to be done by the Prisma client when resolving SQL queries, and the type system won't help us here as this is a runtime issue.

Feel free to escalate this as an issue if it seems like something that's not expected. In the meantime, I'll mark my extension as not compatible with Fluent queries.

How to reproduce (optional)

See issue: 47ng/prisma-field-encryption#80

Expected behavior (optional)

The extension query parameters (in my case, $allOperations) are somehow passed some runtime information about the returned data type when running in a Fluent context, allowing extensions to adapt.

Information about Prisma Schema, Client Queries and Environment (optional)

See issue: 47ng/prisma-field-encryption#80

[nurul3101]

Hello @franky47 👋

Thank you for providing a detailed description of the issue and providing a reproduction.

I would recommend opening a GitHub Issue so that our engineering team can have a look.

Meanwhile, I'll go through the reported issue to check if I am able to reproduce this behaviour.

[franky47]

FYI, I have added an integration test that shows the problem in the extension repo:

1. Clone https://github.com/47ng/prisma-field-encryption
2. Install dependencies with yarn install
3. Build the package with yarn build
4. Run integration tests with yarn test:integration

The incriminating test (showcasing that it does not work with the Fluent API) is here:
https://github.com/47ng/prisma-field-encryption/blob/62055f48fbdc392711bc6dd76fcdaef738a0464d/src/tests/integration.test.ts#L399-L404

If you enable debugging logs with DEBUG="prisma-field-encryption:*" yarn test:integration, it shows that the received query expects a User.findUnique operation, but the returned data is an array of Posts.

[P4sca1]

I opened an issue for this problem:
#21988