{"body":" fernando@Fernandos-MBP-2  ~/Red   master  raku -I. -MRed -e '\r\nmodel ModuleVersion { ... }\r\nmodel Module is table<my_module> {\r\n   has $.id                     is id;\r\n   has $.name                   is column;\r\n   has ModuleVersion @.versions is relationship{ .module-id };\r\n}\r\n\r\n\r\n\r\nmodel ModuleVersion {\r\n   has UInt $!id        is id;\r\n   has UInt $.major     is column;\r\n   has UInt $.minor     is column;\r\n   has UInt $!module-id is referencing(*.id, :model(Module));\r\n   has Module $.module  is relationship(*.module-id);\r\n}\r\n\r\nsub get-db-column-name { \"name\" }\r\n\r\nred-defaults \"SQLite\";\r\n\r\nschema(Module, ModuleVersion).create;\r\n\r\nmy $*RED-DEBUG = True;\r\n\r\n.say for ModuleVersion.^all.grep(*.module.\"{ get-db-column-name }\"() == 1).sort({ -.major, -.minor }).head(1)\r\n\r\n\r\n'\r\nSQL : SELECT\r\n   \"module_version\".id , \"module_version\".major , \"module_version\".minor , \"module_version\".module_id as \"module-id\", \"module_version_module\".id as \"module_version_module.id\", \"module_version_module\".name as \"module_version_module.name\"\r\nFROM\r\n   \"module_version\"\r\n    LEFT JOIN \"my_module\" as module_version_module ON \"module_version\".module_id = \"module_version_module\".id\r\nWHERE\r\n   \"module_version_module\".name = 1\r\nORDER BY\r\n   major DESC,\r\n   minor DESC\r\nLIMIT 1\r\nBIND: []","name":"","extension":"txt","url":"https://www.irccloud.com/pastebin/zhpmmRlT","modified":1622558398,"id":"zhpmmRlT","size":1288,"lines":42,"own_paste":false,"theme":"","date":1622558154}