1. How SQLite Stores Numbers

A binary64 can also be 0.0 (and -0.0), postive [positive] and negative infinity and "NaN" or "Not-a-Number". Floating point values [are] approximate.

It is a mathematical limitation inherient [inherent] in the design of floating-point numbers.

1.2.1. Unrepresentable numbers

Any other numbers to the right of the decimal point result in an approximatation [approximation].

2.2. The decimal.c Extension

These functions respectively add, substract [subtract], and multiply their arguments and return a new text string that is the decimal representation of the result.