select
from
where
insert
into
values
update
set
delete
create
table
alter
drop
index
view
join
inner
left
right
full
outer
cross
on
and
or
not
in
between
like
is
null
as
order
by
asc
desc
group
having
distinct
limit
offset
union
all
exists
case
when
then
else
end
count
sum
avg
min
max
coalesce
cast
convert
concat
substring
trim
upper
lower
length
replace
round
now
date
timestamp
interval
extract
primary
key
foreign
references
unique
check
default
not null
auto_increment
serial
varchar
integer
text
boolean
float
decimal
char
blob
enum
truncate
commit
rollback
transaction
begin
savepoint
grant
revoke
explain
analyze
fetch
cursor
declare
procedure
function
trigger
constraint
cascade
restrict
if
temporary
returning
partition
over
row_number()
rank()
dense_rank()
lag()
lead()
first_value()
last_value()
ntile()
with
recursive
pivot
unpivot
merge
upsert
on conflict
do nothing
do update
ilike
similar to
any
some
lateral
natural
using
except
intersect
window
filter
within group
array_agg()
string_agg()
json_agg()
jsonb
json
unnest
generate_series()
vacuum
reindex
cluster
tablespace
schema
database
sequence
materialized
refresh