Database Detective: Minor Crimes Division

Fixed a parser error when an alias from an outer query is used inside a subquery.

Fixes for Shift key not working on the Steam Deck virtual keyboard, and potential fixes for other keyboard issues related to Shift.

Remedied problems with the Shift key that could affect input across platforms.

Fixed the ability to scroll through the Search Tables window with a scroll wheel.

Tabs were added to the Search Tables window to allow switching between queries more easily.

Queries written in the Search Tables window are now saved and persist after the game is closed.

When preventing cross joins, only queries joined in the FROM statement are counted, preventing false positives in join detection.

Other keyboard-related issues (beyond Shift) may be addressed with upcoming fixes; not explicitly quantified in this patch.

Per-case memory of arrested suspects implemented to prevent duplicate arrests within a single case.

Enhanced validity checks for suspects to reduce false negatives in the validity error popup.

Right-clicking the taskbar now closes the active window or hides all windows for quicker window management.

Dropdowns opened via right-click now animate for a smoother user experience.

Users can indent or unindent selected text in the Search Tables window using Shift and Shift+Tab respectively.

Shift indents and Shift+Tab unindents in the Search Tables window.

The arrest icon is removed after failing the final case to reflect the failed state.

Fix Mac crashing on loading the final two cases to improve stability on macOS.

Restoring queries from Query History now brings the Search Tables window to the top for easier access.

Warnings are now more descriptive to help users understand issues faster.

Queries with non-aggregate columns in HAVING are now blocked to prevent confusing results.

Grouping by column number (GROUP BY 1) no longer warns, matching common SQL behavior.

Fixed cursor misalignment in the Search Tables window after long wrapped text.

Fixed issue where the ending cutscene would not load.

Fixed parser not recognizing quoted identifiers as valid column names when written like [c]tableName."columnName"[/c].

Parser now supports the LIMIT clause in queries.

More specific error messages when a keyword appears after a special character (e.g., a comma) in a FROM or JOIN.

Fixed bug that prevented tables from being downloaded in the final level.

Restored a semicolon that was accidentally removed to fix issues when downloading tables.

Removed separate highlighting for bare LEFT/RIGHT keywords and now only highlights LEFT JOIN and RIGHT JOIN to reduce confusion.

Parser Improvements: Added specific error messages when accessing a column from a table using a comma (table,column) instead of the correct table.column.

Removed cross join errors when joining with subqueries, improving query stability.