RAWSQL_REAL in Tableau: the SQL equivalent, with a worked example

RAWSQL_REAL("%1 * 1.25", [amount])

label	quantity	amount	flag
cedar cedar	65	12.8	True
ORCHID-west	66	-7.6	False
maple-east	67	0	null
willow north	68	25.3	True
birch-birch	69	4.9	False
pine/south	70	-1.2	null
ash	71	9	True
null	null	null	null

SELECT amount * 1.25 AS result FROM input

Runs the example above.

SELECT amount * 1.25 AS result FROM input

Written for this dialect; not run here.

SELECT amount * 1.25 AS result FROM input

Written for this dialect; not run here.

Same rows from the calculation and from the SQL in DuckDB.

Where a naive translation goes wrong

RAWSQL embeds source-dialect SQL; replace the template for the target database.
Naive SQL
```
SELECT amount AS result FROM input
```
result
12.8
-7.6
0
25.3
4.9
-1.2
9
null
Matches the calculation
```
SELECT amount * 1.25 AS result FROM input
```
result
16
-9.5
0
31.625
6.125
-1.5
11.25
null

RAWSQL_REAL(constant_sql, [argument, ...])