Thanks Larry, you point me to the right direction!!!
After turn on quote mode, I see actually sqlite will try to escape single quote again, which means if my output is "''", it will make it to "''''"
```sql
sqlite> .mode quote
sqlite> select simple_query('''');
'"''''"'
```
All I need is return "'", and let sqlite escape for me, Thats awesome!