Andrus Adamchik created CAY-2975:
------------------------------------
Summary: Mnemonic table aliases in generated SQL
Key: CAY-2975
URL: https://issues.apache.org/jira/browse/CAY-2975
Project: Cayenne
Issue Type: Task
Reporter: Andrus Adamchik
Assignee: Andrus Adamchik
Fix For: 5.0-M3
When Cayenne does query to SQL translation, it assigns table aliases like t0,
t1, t2, etc. This is simple to implement, but makes queries less
readable. Let's do a few alias enhacements:
1. When only one table is present in the query, don't use table aliases at all
2. When multiple tables are in use, let's generate more recognizable aliases.
Here is one idea: assume table names are "snake case", and generate aliases
using the first letter of each name part ("user_role" would become "ur"). Cache
precalucalted aliases inside DbEntity. If there is a conflict between aliases
within a query, then use numeric ids. (So the second "ur" would become "ur1",
third - "ur2", etc.)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
