# Pastebin oxepgW1d ➜ Red git:(master) ✗ raku -I. -MRed -e ' model Bla { has $.id is serial; has Str $.a is column } red-defaults "SQLite"; Bla.^create-table; my $*RED-DEBUG = True; .say for Bla.^all.map: { .a.substr(0, 3), .a.substr(3, 5) } ' SQL : SELECT SUBSTR(bla.a, 1, 3) as "data_1", SUBSTR(bla.a, 4, 5) as "data_2" FROM bla BIND: []