fix(session): Windows session list empty when directory uses forward slashes

[XJPeng12]

Description

Description

On Windows, new sessions persist directory with backslashes (e.g. E:\smart_database), while the web app and HTTP API often pass directory with forward slashes (e.g. E:/smart_database from URLs or the SDK).

Session list filters use exact string equality on SessionTable.directory, so requests like GET /session?directory=E:/smart_database&roots=true return [] even when matching rows exist in SQLite. The sidebar session list appears empty for that project.

Expected behavior

Session list returns sessions regardless of whether the query path uses / or \ on Windows.

Actual behavior

Forward-slash and backslash forms of the same Windows path do not match; session list is empty.

Reproduction

1. On Windows, create sessions in a project (directory stored as E:\smart_database)
2. Query sessions via web app or API with directory=E:/smart_database
3. Observe empty session list despite sessions existing in the database

Plugins

No response

OpenCode version

No response

Steps to reproduce

No response

Screenshot and/or share link

No response

Operating System

win10

Terminal

No response

[github-actions]

This issue might be a duplicate of existing issues. Please check:

• fix(session): Windows session directory filters treat slash-equivalent paths as different #28038: Windows session directory filters treat slash-equivalent paths as different (nearly identical issue)
• [Windows] Web UI not showing sessions - path separator mismatch (backslash vs forward slash) #21340: Web UI not showing sessions due to backslash vs forward slash path separator mismatch on Windows
• Sessions missing from sidebar on Windows due to path separator mismatch #23864: Sessions missing from sidebar on Windows due to path separator mismatch

If your issue is indeed the same, please consider closing this one and adding any additional context to the existing reports instead.