How can I write a raw sql query?

The result you see is correct, it is indeed a tuple of {:ok, result}, and the result is a struct indicating that there is no row matching your SQL query (rows is an empty list and num_rows is zero). What is confusing you? What did you expect instead?

Your query selects rows from the game table where name starts with $1#, followed by zero or more characters. Do you have any row in your table that should match that?