Create Domain Specific Language API generator for hand coded FinderImpls

• Type: Story
• Status: Closed
• Priority: Minor
• Resolution: Completed
• Affects Version/s: None
• Fix Version/s: Master
• Component/s: Core Infrastructure
• Labels:
  • 7.3-ce-ga2
  • 7010-sp-pending
  • 7110-sp-pending
  • 7210-sp-pending
  • pt-app-security-review
• Branch Version/s:
  7.2.x, 7.1.x, 7.0.x
• Backported to Branch:
  Committed
• Epic/Theme:
  • Core-Infra-Improvements
• Git Pull Request: https://github.com/shuyangzhou/liferay-portal/pull/8866

Create Domain Specific Language API generator for hand coded FinderImpls.

Main goals of new API:

1. Disallow syntax errors and using database specific clauses
2. Create compile time safety checking for table references between modules
3. Merge locations of SQL with usage to reduce mistakes in FinderImpls
4. Merge SQL generation API with parameter binding API to ensure type safety and correct query parameter binding
5. Easier lookups for DB table sync when using Hibernate
6. Add potential to easily cache queries by column predicates making caching multi-table queries more practical
7. Add potential for safer SQL based APIs