[LogicUpgrade]

There are calculated columns in SQL, which means there's no formula/value separation there either.

Therefore also spreadsheets do offer "views": all the cells are formulas.

Regarding "shit typed", so is SQLite, but it works well.

[PaulHoule]

SQL dbs vary.

You can write

  select a from b where 1

in MySQL and Oracle, because those db's treat true and false as 1 and 0, you can write

  select sum(a=1), sum(a=2) from b

others like microsoft sql and postgresql enforce a separate boolean type which means you have to put the ternary operator into the sum.

[wruza]

By shit typed I meant entering or pasting 1.200 into a numeric field and getting -600,000 something. This is exclusive to excel, which is “smart” enough to detect patterns in input, but not smart enough to introduce/look at the cell affinity, at locale settings or at common sense.