SELECT options for Data Lake

This section describes several SELECT options.

These SELECT options are available:

SELECT

SELECT 
"Order_TSV"."Customer", 
"Order_TSV"."Order", 
"Order_TSV"."OrderDate time", 
"Order_TSV"."OrderNumber" 
FROM 
"Order_TSV"

SELECT (All Variations)

SELECT 
"Order_TSV"."Customer", 
"Order_TSV"."Order", 
"Order_TSV"."OrderDate time", 
"Order_TSV"."OrderNumber" 
FROM 
infor.AllVariations('Order_TSV')

Note: This SELECT option is not available for Views.

SELECT (Include Deleted Rows)

SELECT 
"Order_TSV"."Customer", 
"Order_TSV"."Order", 
"Order_TSV"."OrderDate time", 
"Order_TSV"."OrderNumber" 
FROM 
infor.IncludeDelete('Order_TSV') SELECT (Include Additional Properties)
--*includeInSelectAll=s/g/p/l SELECT * FROM "Order_TSV"

Note: This SELECT option is not available for Views.

SELECT (Skip Reformatting)

--*skipreformatting
SELECT 
"Order_TSV"."Customer", 
"Order_TSV"."Order", 
"Order_TSV"."OrderDate time", 
"Order_TSV"."OrderNumber" 
FROM 
"Order_TSV"

SELECT (Use Titles / Friendly Names)
Generates a SELECT statement that uses Data Catalog titles (friendly names) as table and column aliases instead of technical object and property names. This improves query readability.

These examples compare queries that are generated in the Compass query editor without and with Data Catalog titles.

Query without Data Catalog titles:
```
SELECT
  "MITMAS"."CONO",
  "MITMAS"."STAT",
  "MITMAS"."ITNO"
FROM
  "MITMAS"
```
Query with Data Catalog titles:
```
SELECT
  "MITMAS"."CONO" AS "company",
  "MITMAS"."STAT" AS "status",
  "MITMAS"."ITNO" AS "item number"
FROM
  "MITMAS" AS "Item Master"
```

If no title is defined or the title is empty, no alias is added and the original name is used.