Purpose

Exposing a new hook that is automatically called after a query execution has happened. This hook allows users to place custom logic to handle the results before they are returned back to the user. Situations where this may be useful is when dealing with PII and wanting to verify no information is sent back to the client that shouldn't, or maybe when you want to track how much data is being passed back to the user, audit logs, or more.

You may notice in this PR that we now pass the Env around as well so the afterQuery function has access to it. This allows developers to be able to create other Workers to handle the logic, and this piece of the code can use the Env to access those service bindings. Helps encourage separation of concern code structure.

Tasks

• Expose an afterQuery function that can manipulate or observe query results before sending back to client.

Verify

• Verify existing queries work correctly still

curl --location 'https://starbasedb.YOUR-IDENTIFIER.workers.dev/query' \
--header 'Authorization: Bearer ABC123' \
--header 'Content-Type: application/json' \
--data '{
    "sql": "SELECT * FROM users WHERE user_id=? OR name=?;",
    "params": [1, "Bob"]
}'

Before

After