ACID compliance, rollback, joins, associations, arbitrary SQL

[Vandivier]

Description / Steps to reproduce / Feature proposal

Feature proposal!

Current Behavior

Loopback doesn't have associations https://www.netiq.com/communities/cool-solutions/handling-move-events-and-associations-loopback-driver/

Loopback has trouble with or lacks acid compliance including rollback (unlike, say, Sequelize) https://stackoverflow.com/questions/34965732/how-to-implement-acid-transactions-in-loopback#38231272

Expected Behavior

1. enforce associations for sql
2. Acid compliance for SQL
3. I want to be able to execute arbitrary SQL including flavor-specific queries like SELECT NOW() seamlessly within Loopback instead of having to use two DB management solutions in one app.

See Reporting Issues for more tips on writing good issues

[hvlawren]

In our loopback 3 app, we had to execute some native sql to use some Postgres specific queries (e.g. https://www.postgresql.org/docs/9.6/functions-textsearch.html) for features in some cases (like the fuzzy text matching) and for performance in other (complex multi table joins with many rows per table). Having a more elegant way to do this would be nice.

[stale]

This issue has been marked stale because it has not seen activity within six months. If you believe this to be in error, please contact one of the code owners, listed in the CODEOWNERS file at the top-level of this repository. This issue will be closed within 30 days of being stale.

[stale]

This issue has been closed due to continued inactivity. Thank you for your understanding. If you believe this to be in error, please contact one of the code owners, listed in the CODEOWNERS file at the top-level of this repository.

[achrinza]

Related: #2331