D1 Provider: `Query error: 404 Client Error`

[jegork]

It seems like the URL here is incorrect:

sqlit/sqlit/domains/connections/providers/d1/adapter.py

Line 129 in 8f9bf98

api_url = f"{self._api_base_url()}/client/v4/accounts/{conn.account_id}/d1/database/{conn.database_id}/execute"

I am getting [12:28:34] Query error: 404 Client Error: Not Found for url: https://api.cloudflare.com/client/v4/accounts/<account-id>/d1/database/<database-id>/execute

From cloudflare docs it seems like the correct path is /query instead of /execute
https://developers.cloudflare.com/api/resources/d1/subresources/database/methods/query/