refactor: remove outdated query modifiers (#311) #560

	name: psql Test

	on:
	push:
	branches: [ "main" ]
	pull_request:
	branches: [ "main" ]

	jobs:

	build:
	runs-on: ubuntu-latest
	steps:
	- uses: actions/checkout@v4

	- name: Set up Go
	uses: actions/setup-go@v5
	with:
	go-version: '1.23'

	- name: Set up Python
	uses: actions/setup-python@v5
	with:
	python-version: '3.10'

	- name: Install system packages
	uses: awalsh128/cache-apt-pkgs-action@latest
	with:
	packages: postgresql-client
	version: 1.0

	- name: Install dependencies
	run: \|
	go get .

	pip3 install "sqlglot[rs]" pyarrow pandas

	curl -LJO https://github.com/duckdb/duckdb/releases/latest/download/duckdb_cli-linux-amd64.zip
	unzip duckdb_cli-linux-amd64.zip
	chmod +x duckdb
	sudo mv duckdb /usr/local/bin

	- name: Build
	run: go build -v

	- name: Start MyDuck Server
	run: \|
	./myduckserver &
	sleep 5

	- name: Run the SQL scripts
	run: \|
	# for each SQL script in the `pgtest/psql` directory (recursively)
	for f in pgtest/psql/*/.sql; do
	psql -h 127.0.0.1 -U postgres -d postgres -f $f
	done

Provide feedback