3 ms·
The ORM I really want just takes my SQL and a connection to my database at compile or load time, and wires it up to the type system of the language I'm using. A
by bcoates 13y ago
The ORM I really want just takes my SQL and a connection to my database at compile or load time, and wires it up to the type system of the language I'm using. All the ones I've tried just seem to embrace the awfulness of the low-level database access APIs and are just trying to replace the good-enough DSL that is SQL with something worse.
- tmcneal 13y agoThe closest I've seen an ORM come to this is Squeryl: http://squeryl.org http://squeryl.org
- oacgnol 13y agoWhich has been superseded by Slick (http://slick.typesafe.com/ http://slick.typesafe.com/) and does exactly as the parent says.
- johnpmayer 13y agohttp://www.haskell.org/haskellwiki/MetaHDBC http://www.haskell.org/haskellwiki/MetaHDBC Does exactly that. Runs your SQL against the database at compile time to get type information, which it injects into the program AST.
- kingkilr 13y agoIt's 100% possible to use SQLAlchemy to do that in Python.
- pdpi 13y agoIn that regard, while not actually an ORM per se, one of the best experiences I've ever had with SQL integration in a language was SAP's ABAP, where column types and data types are (almost?) the exact same thing.
- stonemetal 13y agoIf you are in C# land Dapper does a good job of letting you write SQL and handle the messy put result sets in to objects part of the equation.