feat(ENG-373): add configurable table_scope to FunctionNode and OperatorNode #112

	name: Run PostgreSQL Tests

	on:
	push:
	branches: [main, dev]
	pull_request:
	branches: [main, dev]
	workflow_dispatch: # Allows manual triggering

	jobs:
	test:
	runs-on: ubuntu-latest
	strategy:
	matrix:
	python-version: ["3.11", "3.12"]

	services:
	postgres:
	image: postgres:16
	env:
	POSTGRES_PASSWORD: postgres
	POSTGRES_DB: testdb
	POSTGRES_USER: postgres
	ports:
	- 5432:5432
	options: >-
	--health-cmd pg_isready
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5

	steps:
	- uses: actions/checkout@v4

	- name: Install uv
	uses: astral-sh/setup-uv@v5

	- name: Set up Python ${{ matrix.python-version }}
	uses: actions/setup-python@v5
	with:
	python-version: ${{ matrix.python-version }}

	- name: Install system dependencies
	run: sudo apt-get update && sudo apt-get install -y graphviz libgraphviz-dev

	- name: Install dependencies
	run: uv sync --locked --all-extras --dev

	- name: Run PostgreSQL tests
	run: uv run pytest -v -m postgres --postgres --cov=src --cov-report=term-missing --cov-report=xml
	env:
	PGHOST: localhost
	PGPORT: 5432
	PGUSER: postgres
	PGPASSWORD: postgres
	PGDATABASE: testdb

	- name: Upload coverage reports to Codecov
	uses: codecov/codecov-action@v5
	with:
	token: ${{ secrets.CODECOV_TOKEN }}

Provide feedback