Overhaul BACK and CALC to use downstreaming of aliases and add CALCULATE method #1065

	name: PR Testing

	on:
	pull_request:

	# Limit CI to cancel previous runs in the same PR
	concurrency:
	group: ${{ github.workflow }}-${{ github.head_ref \|\| github.ref_name }}
	cancel-in-progress: true

	jobs:
	get-msg:
	name: Get Commit Message
	runs-on: ubuntu-latest
	outputs:
	commitMsg: ${{ steps.get_msg.outputs.commitMsg }}
	steps:
	# Fetch the branch for the history only
	- uses: actions/checkout@v4
	with:
	ref: ${{ github.event.pull_request.head.sha }}
	sparse-checkout: .
	- name: Get Commit Message
	id: get_msg
	run: \|
	set -xe pipefail
	echo "commitMsg=$(git log -1 --pretty=format:'%s')" >> $GITHUB_OUTPUT

	run-tests:
	strategy:
	matrix:
	python-version:
	- "3.10"
	- "3.11"
	- "3.12"
	needs: [get-msg]
	name: python
	runs-on: ubuntu-latest
	# https://docs.github.com/en/actions/learn-github-actions/expressions#contains
	# contains is case-insensitive
	if: contains(needs.get-msg.outputs.commitMsg, '[run ci]')
	steps:
	- name: Checkout code
	uses: actions/checkout@v4

	- name: Install uv
	uses: astral-sh/setup-uv@v3
	with:
	# Install a specific version of uv.
	version: "0.4.23"

	- name: Setup Defog DB
	run: cd tests; ./setup_defog.sh; cd ..

	- name: Download TPCH DB
	run: ./demos/setup_tpch.sh ./tpch.db

	- name: Run Ruff
	run: uv run --python ${{ matrix.python-version }} ruff check .

	- name: Run Tests
	run: uv run --python ${{ matrix.python-version }} pytest tests/

Provide feedback