Is there an efficient way to approximate ST_GeneratePoints in SpatiaLite?
Here's one approach I can think of: get the bounding box of a geometry, then generate random points within the box using the standard random()
function, and finally find the random points that intersect with the original geometry.
That would probably need to be implemented recursively to ensure that you actually got the desired number of points.