Aside from small syntax differences in generated SQL, Drizzle's mysql connectors are actually pretty close to providing a nice Manticore ORM experience! Describe the solution you'd like Ideally ...

SQL I'm using is one to pull out a Nested Set data structure for a hierarchical tree of stuff: SELECT node.id, node.name, (COUNT(parent.name) - (sub_tree.depth + 1)) AS depth ...