Add test to verify native query Session flush behavior