// postgres_restricted_word_insert.ts
import postgres from 'postgres';

(async function run() {
  const sql = postgres(process.env.DATABASE_URL || 'postgres://localhost:5432/test');

  await sql`
    DROP TABLE IF EXISTS users
  `;

  await sql`
    CREATE TABLE users (
      "user" varchar(255) NOT NULL,
      CONSTRAINT users_pk PRIMARY KEY ("user")
    );
  `;

  // Works
  console.info('Step 1: Insert user with manually escaping restricted word');
  const rows = await sql`
    INSERT INTO users ("user") VALUES('test user')
  `;
  console.info('Step 1: Completed\n')

  // Does not work
  console.info('Step 2: Insert user by using JS object');
  const user = { user: 'another test user' };
  await sql`
    INSERT INTO users ${sql(user, 'user')}
  `.catch(() => {
    console.error('Step 2: As expected, it did fail...');
    return Promise.resolve();
  });
  console.info('Step 2: Completed\n');

  console.info('All done!');

  process.exit();
})();