I'm pretty new to node, and I was wondering if there's any standard, open, api that could abstract me away from all the different database idiosyncrasies.
Any link with tutorials or documentation would be pretty much welcome indeed
There's not a "standard" db abstraction layer for Node, but take a look at Node-DBI which is open-source and maintained on GitHub. There are probably others but this one has a good interface and several adapters already.
There are none that I know of, and looking at the official node documentation doesn't list anything of the sort, which is disappointing.
If you're not opposed to using an ORM then Sequelize is a pretty good option, it only handles a subset of SQL, but it . This Project looks like an effort to do what you described; however, that project looks like it was last updated a long while ago.