postgresql/consistent-as-for-table-alias

Why this matters

Same rationale as `consistent-as-for-column-alias`: explicit `AS` makes the alias unmistakable and helps human readers spot stray missing commas in the FROM list. Flip with the `style` option if your project prefers the bare form.

Examples

SELECT u.id FROM users u WHERE u.active = TRUE;

SELECT u.id FROM users AS u WHERE u.active = TRUE;

SELECT u.id FROM users WHERE active = TRUE;

Configure it

// eslint.config.js
import postgresql from "eslint-plugin-postgresql";

export default [
  {
    files: ["**/*.sql"],
    languageOptions: {
      parser: postgresql.configs.recommended.languageOptions.parser,
    },
    plugins: { postgresql },
    rules: {
      "postgresql/consistent-as-for-table-alias": [
        "warn",
        {
          style: "always",
        },
      ],
    },
  },
];

Options

style "always" | "never" default: "always"

`always` (default) requires `AS` before table aliases. `never` forbids the keyword.