Handling JSONB fields in SQL queries with TypeScript can be tricky due to type constraints. In yo...

INSERT INTO publications ${sql(
    publication,
    'id',
    'ownerId',
    'avatar',
    'title',
    'slug',
    'description',
    'socials',
    'settings',
)}
ON CONFLICT (id) DO UPDATE
SET ${sql(publication, 'avatar', 'title', 'description', 'socials', 'settings')}

const InsertPublicationSchema = Publication.pipe(
    S.pick(
        "id",
        "ownerId",
        "avatar",
        "title",
        "slug",
        "description",
        "socials", // JSONB column
        "settings", // JSONB column
    ),
);

const Save = SqlSchema.void({
    Request: InsertPublicationSchema,
    execute: (publication) => sql`
        INSERT INTO publications
            ${sql.insert(publication)}
        ON CONFLICT (id) DO UPDATE
        SET
            avatar = excluded.avatar,
            title = excluded.title,
            description = excluded.description,
            socials = excluded.socials,
            settings = excluded.settings
    `,
});