• I know exactly what to write. And it would take fewer keystrokes to command GPT to write it instead. All I have to do is review and accept. (Boilerplate, Type/Interface definitions, formating, repetitive tasks)
• I'm exploring an idea or looking for existing tools/methods. I use the Chat feature like a search engine/wiki to assist in exploration. GPT helps me bridge small gaps in knowledge.

• I have large gaps in knowledge
• The work is novel or less researched/documented.
• Also, I notice that GPT will usually default to the most generic and general way to solve a problem, not necessarily the best way. For example, it will reinvent the wheel by implementing a complex algorithm poorly rather than use a library or existing method that is more efficient. I have yo specifically ask if there are any libraries that would simplify things.

CREATE OR REPLACE FUNCTION timewarp()
RETURNS VOID LANGUAGE plpgsql AS $$
DECLARE
  r RECORD;
  max_timestamp TIMESTAMP;
  interval_to_add INTERVAL;
BEGIN
  FOR r IN SELECT c.table_schema, c.table_name, c.column_name
           FROM information_schema.columns c
           JOIN information_schema.tables t ON c.table_schema = t.table_schema AND c.table_name = t.table_name
           WHERE c.data_type IN ('timestamp without time zone', 'timestamp with time zone')
           AND c.table_schema NOT IN ('pg_catalog', 'information_schema') -- Exclude system schemas
           AND t.table_type = 'BASE TABLE' -- Ensure targeting only user-defined tables (excluding views)
           AND t.table_schema NOT LIKE 'pg_%' -- Exclude other potential PostgreSQL system schemas
  LOOP
    -- Calculate the maximum value in the column
    EXECUTE format('SELECT max(%I) FROM %I.%I', r.column_name, r.table_schema, r.table_name) INTO max_timestamp;

    -- If there's a maximum value, calculate the interval and update the column
    IF max_timestamp IS NOT NULL THEN
      interval_to_add := now() - max_timestamp;
      EXECUTE format('UPDATE %I.%I SET %I = %I + %L', r.table_schema, r.table_name, r.column_name, r.column_name, interval_to_add);
    END IF;
  END LOOP;
END;
$$;

I see tweets and posts from devs saying they use it all the time to build things, find bugs, cut 50% or more of their workflow, and that it’s a huge game changer… But that all seems hard to believe.