> I suppose using functions defined by the host with SQLite is cheaper than using similarly defined functions in databases that are separated by a network.

“Infeasible” is very fast. sqlite runs in process so you can register a function pointer or five, with a trampoline back into the runtime.

Can’t do that over the network, you can create functions but only using the database’s procedural langage(s in the case of Postgres).