Bug: dry-run seems to be bypassed

[euri10]

Description

downgrading from 2 to 1 with dry-run should not apply the migration or I am missing something ?

❯ sqlspec --config availify.main_sqlspec.main show-current-revision
Listing current revision ────────────────────────────────────────────────────────────────────────────────────────────────
Current version: 0002
❯ sqlspec --config availify.main_sqlspec.main downgrade --dry-run
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-16 18:41:27,011 - sqlspec.loader - loader - Loading SQL files
INFO - 2025-10-16 18:41:27,013 - sqlspec.loader - loader - Loaded 1 SQL files with 2 new queries in 1.425ms
INFO - 2025-10-16 18:41:27,013 - sqlspec.loader - loader - Loading SQL files
INFO - 2025-10-16 18:41:27,013 - sqlspec.loader - loader - Loaded 1 SQL files with 2 new queries in 0.346ms

Reverting 0002: oauth
INFO - 2025-10-16 18:41:27,014 - sqlspec.loader - loader - Loading SQL files
INFO - 2025-10-16 18:41:27,014 - sqlspec.loader - loader - Loaded 1 SQL files with 0 new queries in 0.144ms
✓ Reverted in 12ms
❯ sqlspec --config availify.main_sqlspec.main show-current-revision
Listing current revision ────────────────────────────────────────────────────────────────────────────────────────────────
Current version: 0001

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

main

Platform

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