Provide support for "Suffixes to ignore" in "Insert code > Aliasing" options
We use a data warehousing strategy that creates potentially dozens of tables for multi-class entities in the data warehouse, so we have many tables that end in "core". This leads SQL Prompt to alias the object with a final "C" that we then remove manually. For example, our InstanceCore and Database_Core tables are aliased to "IC" and "DC" when we would prefer "I" and "D" respectively.
Can SQL Prompt's Aliasing capabilities be extended to support "Suffixes to ignore" just like the existing "Prefixes to ignore"?
John Barone commented
I second this request! I work with a DBAmp-powered SQL mirror of a Salesforce instance, and it chock full of "__c" suffixes; the naming convention uses the "__c" to denote a a custom table as opposed to a built-in one. So a table named "address__c" ends up being "ac" instead of just "a".