Creating composite types in PostgreSQL

-- composite type
CREATE TYPE author AS (
    name text,
    role text
);

CREATE TABLE books (
    book_id serial PRIMARY KEY,
    title text,
    authors author[]
);

type Author = {
    name: string;
    role: string;
};

const books = pgTable('books', {
    bookId: serial('book_id').primaryKey(),
    title: text('title'),
    authors: text('authors').array().$type<Author>(),
});