The GUI client will have needed to add support for D1 HTTP API

CREATE TABLE `experiences` (
    `id` text PRIMARY KEY NOT NULL,
    `name` text NOT NULL
);

CREATE TABLE `users` (
    `id` text PRIMARY KEY NOT NULL,
    `name` text NOT NULL
);

CREATE TABLE `experience_owners` (
    `experience_id` text NOT NULL,
    `user_id` text NOT NULL,
    PRIMARY KEY(`experience_id`, `user_id`),
    FOREIGN KEY (`experience_id`) REFERENCES `experiences`(`id`) ON UPDATE no action ON DELETE cascade
    FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON UPDATE no action ON DELETE no action
);

insert into experiences (id, name) VALUES (1, 'owning a house');
insert into users (id, name) VALUES (1, 'some guy');
insert into experience_owners (experience_id, user_id) VALUES (1,1);

CREATE TABLE `experiences` (
    `id` text PRIMARY KEY NOT NULL,
    `name` text NOT NULL
);

CREATE TABLE `users` (
    `id` text PRIMARY KEY NOT NULL,
    `name` text NOT NULL
);

CREATE TABLE `experience_owners` (
    `experience_id` text NOT NULL,
    `user_id` text NOT NULL,
    PRIMARY KEY(`experience_id`, `user_id`),
    FOREIGN KEY (`experience_id`) REFERENCES `experiences`(`id`) ON UPDATE no action ON DELETE cascade
    FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON UPDATE no action ON DELETE no action
);

insert into experiences (id, name) VALUES (1, 'owning a house');
insert into users (id, name) VALUES (1, 'some guy');
insert into experience_owners (experience_id, user_id) VALUES (1,1);