# Pastebin 7x4dUW9u ➜ Red git:(master) ✗ raku -I. -MRed -MRed::Type::Json -e ' model Bla { has $.id is serial; has Json $.a is column } red-defaults "SQLite"; Bla.^create-table; my $*RED-DEBUG = True; .say for Bla.^all.map: { .a, .a[0] } ' SQL : SELECT JSON_EXTRACT(bla.a, '$.key1') as "data_1", JSON_EXTRACT(bla.a, '$.key2[0]') as "data_2" FROM bla BIND: []