Bug: duplicate loading ?

[euri10]

Description

one single migration file leads to this:

❯ sqlspec --config availify.main_sqlspec.main upgrade
Starting database upgrade process ────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
Are you sure you want migrate the database to the `head` revision? [y/n]: y
Found 1 pending migrations
INFO - 2025-10-10 16:26:32,518 - sqlspec.loader - loaders - Loading SQL files
INFO - 2025-10-10 16:26:32,519 - sqlspec.loader - loaders - Loaded 1 SQL files with 2 new queries in 0.883ms
INFO - 2025-10-10 16:26:32,519 - sqlspec.loader - thread - Loading SQL files
INFO - 2025-10-10 16:26:32,522 - sqlspec.loader - thread - Loaded 1 SQL files with 2 new queries in 2.596ms

Applying 0001: users
INFO - 2025-10-10 16:26:32,522 - sqlspec.loader - loaders - Loading SQL files
INFO - 2025-10-10 16:26:32,522 - sqlspec.loader - loaders - Loaded 1 SQL files with 2 new queries in 0.216ms
✓ Applied in 12ms

URL to code causing the issue

No response

MCVE

# Your MCVE code here

Steps to reproduce

1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error

Screenshots

"In the format of: ![SCREENSHOT_DESCRIPTION](SCREENSHOT_LINK.png)"

Logs

Package Version

0.26.0

Platform

• Linux
• Mac
• Windows
• Other (Please specify in the description above)

[euri10]

I think this is stil an issue if I'm not mistaken:

❯ uv remove sqlspec
Resolved 55 packages in 79ms
      Built availify @ file:///home/lotso/PycharmProjects/availify
Prepared 1 package in 280ms
Uninstalled 3 packages in 6ms
Installed 1 package in 0.64ms
 ~ availify==0.1.0 (from file:///home/lotso/PycharmProjects/availify)
 - sqlglot==27.26.0
 - sqlspec==0.27.0 (from git+https://github.com/litestar-org/sqlspec@297e4dee6ae18fbdcfe1c21b19d040d8186f4983)
❯ uv add git+https://github.com/litestar-org/sqlspec
Resolved 57 packages in 70ms
      Built availify @ file:///home/lotso/PycharmProjects/availify
Prepared 1 package in 316ms
Uninstalled 1 package in 0.37ms
Installed 3 packages in 3ms
 ~ availify==0.1.0 (from file:///home/lotso/PycharmProjects/availify)
 + sqlglot==27.26.0
 + sqlspec==0.27.0 (from git+https://github.com/litestar-org/sqlspec@297e4dee6ae18fbdcfe1c21b19d040d8186f4983)
❯ sqlspec --config availify.main_sqlspec.main upgrade
Starting database upgrade process ───────────────────────────────────────────────────────────────────────────────────────
Are you sure you want migrate the database to the `head` revision? [y/n]: y
Already at latest version
❯ sqlspec --config availify.main_sqlspec.main downgrade
Starting database downgrade process ─────────────────────────────────────────────────────────────────────────────────────
Are you sure you want to downgrade the database to the `-1` revision? [y/n]: y
Reverting 1 migrations
INFO - 2025-10-11 08:53:59,157 - sqlspec.loader - loader - Loading SQL files
INFO - 2025-10-11 08:53:59,162 - sqlspec.loader - loader - Loaded 1 SQL files with 2 new queries in 5.000ms
INFO - 2025-10-11 08:53:59,162 - sqlspec.loader - loader - Loading SQL files
INFO - 2025-10-11 08:53:59,163 - sqlspec.loader - loader - Loaded 1 SQL files with 2 new queries in 0.389ms

Reverting 0001: users
INFO - 2025-10-11 08:53:59,164 - sqlspec.loader - loader - Loading SQL files
INFO - 2025-10-11 08:53:59,164 - sqlspec.loader - loader - Loaded 1 SQL files with 0 new queries in 0.117ms
✓ Reverted in 5ms
❯ sqlspec --config availify.main_sqlspec.main upgrade
Starting database upgrade process ───────────────────────────────────────────────────────────────────────────────────────
Are you sure you want migrate the database to the `head` revision? [y/n]: y
Found 1 pending migrations
INFO - 2025-10-11 08:54:03,372 - sqlspec.loader - loader - Loading SQL files
INFO - 2025-10-11 08:54:03,373 - sqlspec.loader - loader - Loaded 1 SQL files with 2 new queries in 1.338ms
INFO - 2025-10-11 08:54:03,373 - sqlspec.loader - loader - Loading SQL files
INFO - 2025-10-11 08:54:03,374 - sqlspec.loader - loader - Loaded 1 SQL files with 2 new queries in 0.371ms

Applying 0001: users
INFO - 2025-10-11 08:54:03,374 - sqlspec.loader - loader - Loading SQL files
INFO - 2025-10-11 08:54:03,375 - sqlspec.loader - loader - Loaded 1 SQL files with 0 new queries in 0.155ms
✓ Applied in 12ms
  ~/PycharmProjects/availify   main +36 !23 ?3 ❯       

[euri10]

I'm reopening @cofin idk if you saw my earlier comment on this, I know gh notifications sometimes are weird...