Hi Christopher,
What is happening is that you are testing the SQL with the Test button, right?
When you do this, the query is effectively executed in the database, so your select, after the insert, given your output structure is correct, will show that the row was inserted.
But as soon as this ends, as this is just a test, it will abort the transaction and roll back any change.
That's the reason why you're not seeing the results being persistent.
If you create a page with a button to can a screen action to execute this query from the browser, assuming no errors in the query, it should be persistent in database.
Cheers