You're absolutely right JQL alone doesn’t let you fetch status transition timestamps directly. It’s a common limitation.
If you're open to lightweight apps, you might find Flow Time Report helpful. It shows exactly when an issue entered and exited each status including “doing” and “done” right inside the issue panel.
It also highlights how long each step took, which can be useful for retro insights or process improvements.