SQLite Forum

SQL to return list of PRAGMAs
1. [it's an SQLite extension, from DRH himself](https://www.sqlite.org/geopoly.html)
2. Not sure what you mean. Of course they can be used.
3. Many things in SQLite can be turned ON/OFF by a `#define`, including Geopoly.

So your *Out-of-the-Box* is simply that whoever built the SQLite lib or CLI you used,  
included the **Geopoly** extension in the build, that's it.

Whether it should be considered *built-in* or not, well, who cares?  
It does come from the SQLite3 authors (the main one in fact), but since  
it's an extension, that's likely why it's not considered *built-in* I suspect. FWIW.