From 0bbfd5f8326fd4291c390858ba8ff482ff5ced70 Mon Sep 17 00:00:00 2001
From: Andi Albrecht <albrecht.andi@gmail.com>
Date: Wed, 24 Aug 2022 20:42:01 +0200
Subject: Add DISTINCTROW keyword (fixes #677).

---
 CHANGELOG            | 1 +
 sqlparse/keywords.py | 6 ++++++
 2 files changed, 7 insertions(+)

diff --git a/CHANGELOG b/CHANGELOG
index 8ebb6e3..10185b2 100644
--- a/CHANGELOG
+++ b/CHANGELOG
@@ -7,6 +7,7 @@ Enhancements
 * Add support for additional SPARK keywords (pr643, by mrmasterplan).
 * Avoid tokens copy (pr622, by living180).
 * Add REGEXP as a comparision (pr647, by PeterSandwich).
+* Add DISTINCTROW keyword for MS Access (issue677).
 
 Bug Fixes
 
diff --git a/sqlparse/keywords.py b/sqlparse/keywords.py
index 29f27af..0f3a459 100644
--- a/sqlparse/keywords.py
+++ b/sqlparse/keywords.py
@@ -16,6 +16,7 @@ def is_keyword(value):
             or KEYWORDS_ORACLE.get(val)
             or KEYWORDS_PLPGSQL.get(val)
             or KEYWORDS_HQL.get(val)
+            or KEYWORDS_MSACCESS.get(val)
             or KEYWORDS.get(val, tokens.Name)), value
 
 
@@ -962,3 +963,8 @@ KEYWORDS_HQL = {
     'BREAK': tokens.Keyword,
     'LEAVE': tokens.Keyword,
 }
+
+
+KEYWORDS_MSACCESS = {
+    'DISTINCTROW': tokens.Keyword,
+}
-- 
cgit v1.2.1