3 ms·
One of the advantages of just having your embedded SQL as a string is that you can copy it back and forth between a SQL console when you are developing. Instea
by throwaway4good 6y ago
One of the advantages of just having your embedded SQL as a string is that you can copy it back and forth between a SQL console when you are developing.
Instead of something like this:
Query query = create.select(field("BOOK.TITLE"), field("AUTHOR.FIRST_NAME"), field("AUTHOR.LAST_NAME"))
.from(table("BOOK"))
.join(table("AUTHOR"))
.on(field("BOOK.AUTHOR_ID").eq(field("AUTHOR.ID")))
.where(field("BOOK.PUBLISHED_IN").eq(1948));
Plus you may sit with a SQL dialect not supported by the "Fluent API".