Possible to see solution before starting mystery about sql-mysteries HOT 2 OPEN

Well, I'd argue this is not an issue. If you are able to solve the mystery this way, solving it the intended way should be trivial.

It's rather a good third challenge, finding both culprits, using a single query, mastering some more advanced SQL concepts:

WITH RECURSIVE split(content, last, rest) AS (
VALUES('', '', (select sql from sqlite_master where type = 'trigger' and name = 'check_solution'))
UNION ALL
  SELECT 
    CASE WHEN last = "'" 
            THEN
                substr(rest, 1, 1)
            ELSE
                content || substr(rest, 1, 1)
    END,
     substr(rest, 1, 1),
     substr(rest, 2)
  FROM split
  WHERE rest <> ''
)
SELECT 
       name     
FROM 
       split, person
WHERE 
       (last = "'" OR rest ='') AND hex(name) = REPLACE(content, "'",'');```
    
</details>  

from sql-mysteries.

If this was like CTF game, seeing the trigger's source code to check the answer would be a great solution (I did try this as my first attempt hehe), but this is more of a fun detective game to train/learn sql, so being able to see the answer right away with little modification kinda defeat the purpose.
Maybe keep it as possibility like we can do this after solving the intended way. So when we try to query the trigger, it give the result like " Haha, nice one detective, it is indeed a fast way to solve this mystery, but hey you are the greatest detective!, no need to cheat, use your SQL and BrainPower!. You can do this after solving the mystery"

from sql-mysteries.