perf(sql): Add `COLLATE NOCASE` to some indexes on `ahb_hierarchy_materialized` for faster search #525

	name: "Test Dev Environment"
	# Checks that the dev environment (tox -e dev) can be set up.
	# This might not work, if different linting/testing envs refer to different versions of the same lib (e.g. typing-extensions).
	# Different versions of the same package might work for isolated specific envs (only linting, only testing...) but the dev environment inherits from all of them.
	on:
	push:
	branches: [main]
	pull_request: {}
	jobs:
	check:
	runs-on: ubuntu-latest
	strategy:
	matrix:
	python-version: ["3.11", "3.12", "3.13", "3.14"]
	steps:
	- uses: actions/checkout@v5
	- name: Set up Python ${{ matrix.python-version }}
	uses: actions/setup-python@v6
	with:
	python-version: ${{ matrix.python-version }}
	- name: Install Dependencies
	run: \|
	python -m pip install --upgrade pip
	pip install tox
	- name: Create a Dev Environment
	run: \|
	tox -e dev

Provide feedback