SQLite Forum

Use custom string function in FTS5 match clause
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 "''''"

sqlite> .mode quote
sqlite> select simple_query('''');

All I need is return "'", and let sqlite escape for me, Thats awesome!