pathakpk7/Murder_Mystery_Game ? reverse-engineered prompt

Build me a story driven murder mystery game where the player solves a long detective thriller by writing SQL queries.

I want a simple backend that serves the game data and works with a database, plus a browser based single page frontend that can be opened directly. The main experience should feel like a case file investigation, where each chapter has suspects, witnesses, evidence, forensics, and a timeline that the player can query to uncover the truth.

The game should guide the player through 18 cases, starting from an onboarding case and ending with a final reveal of the mastermind. There should be a SQL query editor, feedback on whether the query helps solve the case, case progression, star rewards, XP, and rank upgrades as the player advances. Include a hints area too, and make the whole thing feel dramatic and immersive like a detective thriller. If you need current docs or examples for anything, look them up online first.