Additional string functions. Adapted from extension-functions.c by Liam Healy.
Provides following functions:
Returns reversed string.
sqlite> select reverse('hello world');
dlrow olleh
Splits source string on sep and returns the given part (counting from one).
sqlite> select split_part('one;two;three', ';', 2);
two
sqlite> select split_part('one;;three', ';', 2);
If sep is composed of multiple characters, each character is treated as separator. E.g.:
sqlite> select split_part('one/two\three', '/\', 2);
two
Only ASCII (1-byte) symbols are supported as separators.
sqlite> .load ./text
sqlite> select reverse('hello');