Refactor example build and run logic in CI workflow for improved clar… #3

	name: CI

	on:
	pull_request:
	push:
	branches:
	- main

	jobs:
	test:
	runs-on: ubuntu-latest
	env:
	GOFLAGS: -mod=mod
	steps:
	- name: Checkout
	uses: actions/checkout@v4

	- name: Set up Go
	uses: actions/setup-go@v4
	with:
	go-version: '1.24.2'

	- name: Set DUCKDB_HOME environment variable
	run: echo "DUCKDB_HOME=${{ runner.temp }}/duckdb-home" >> $GITHUB_ENV

	- name: Set GOMODCACHE environment variable
	run: echo "GOMODCACHE=$(go env GOMODCACHE)" >> $GITHUB_ENV

	- name: Ensure DUCKDB_HOME exists
	run: mkdir -p "${{ env.DUCKDB_HOME }}"

	- name: Install system build deps
	run: \|
	sudo apt-get update
	sudo apt-get install -y build-essential pkg-config

	- name: Run tests
	run: \|
	# run all tests with verbose output
	go test ./... -v

	- name: Build and run examples
	run: \|
	for f in example/*.go; do
	fname=$(basename "$f" .go)
	echo "Building $f -> $fname"
	go build -o "example/$fname" "$f"
	echo "Running example/$fname"
	"example/$fname"
	done

Provide feedback