Feature Request: Config for uppercase / lowercase data types

[karlhorky]

Describe the Feature

Currently, using keywordCase: 'upper' results in

CREATE TABLE
  users (
    id INTEGER PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
    username VARCHAR(30) NOT NULL UNIQUE,
    password_hash VARCHAR(60) NOT NULL
  );

It would be nice to have an option (eg. dataTypeCase, could default to keywordCase value for backwards compatibility) to format the data types (integer, varchar, any other data types) as lowercase, since this is the style in the PostgreSQL docs:

CREATE TABLE
  users (
    id integer PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
    username varchar(30) NOT NULL UNIQUE,
    password_hash varchar(60) NOT NULL
  );

Why do you want this feature?

This is the style in the PostgreSQL docs.

[nene]

Yeah, makes sense. Especially as some SQL dialects treat data type names as keywords and others do not. Also, this would alleviate a general problem with the formatter not understanding the context where a keyword is used.

[nene]

Also relates to: #641

[karlhorky]

Potential alternatives from #156 (comment) would be

1. accepting an object for the option keywordCase, for granular configuration:

const options = {
  language: 'postgresql',
  keywordCase: {
    upper: true, // true: default case
    lower: ['name', 'varchar', 'integer'],
    preserve: ['in'],
  },
}

2. an option keywordCaseIgnore (array), which would allow for more flexible customization (would not allow for same configurability, I prefer option 1)

const options = {
  language: 'postgresql',
  keywordCase: 'upper',
  keywordCaseIgnore: [
    // Avoid changing case of `name` fields in tables
    'name',
    // Avoid changing case of data types
    'varchar',
    'integer',
    // ...
  ],
}