Getting 'failed to execute SQL' error instead of constraint error

I have a users table in Turso where the id is a primary key and the email field has a unique index constraint. When I attempt to insert a row with a duplicate id or a duplicate email, I only receive the following error:

insert into users (id, email) values('duplicateid', 'duplicate@email.com');
Error: failed to execute SQL: insert into users (id, email) values('duplicateid', 'duplicate@email.com');

The row is inserted successfully when the values are unique.

When I attempt to insert a row with a duplicate email in my application, I get the following error

HttpServerError: Server returned HTTP status 500

This is the schema for the user table:

CREATE TABLE `users` (
  `id` text PRIMARY KEY NOT NULL,
  `name` text,
  `email` text NOT NULL,
  `hash` text,
  `role` text DEFAULT 'user',
  `created_at` text DEFAULT CURRENT_TIMESTAMP NOT NULL
);

CREATE UNIQUE INDEX `users_email_unique` ON `users` (`email`);

I would appreciate any input on receiving detailed errors.

Use the duplicate-id and duplicate-email INSERT examples with the shown users schema to reproduce the generic failure. Trace the SQL execution and error path in libSQL; done means constraint violations expose detailed errors instead of only “failed to execute SQL” or an HTTP 500 response.