Find all segments of a LineString within distance of a point

Recently I was asked:

Is it possible to find all the line string with in certain distance from a point (lat, lon).

It is a pretty simple question (if I interpret it correctly).

Here is a solution for Oracle Spatial:

With Data As (
  Select Sdo_Geometry('POINT (14.2253521142857 12.5352112685714)',4326) As Point,
         Sdo_Geometry('LINESTRING(14.22498795 12.53599561, 14.22520505 12.53554742, 14.22477786 12.53554041, 14.22519804 12.53534433,14.22473584 12.53509222, 14.22517003 12.53512723, 14.22517703 12.53465803, 14.22534511 12.5350572,14.22621348 12.53449696, 14.22545716 12.53525329, 14.22638856 12.53579252, 14.22534511 12.53543537,14.22549217 12.5362127, 14.22554819 12.5362127)',4326) As Line
   from dual
)
Select Sdo_Geom.Sdo_Intersection(
          A.Line,
          Sdo_Geom.Sdo_Buffer(A.Point,25.0,0.05),
          0.05
       ).get_wkt() As iGeom
  from data a;

IGEOM
-----
MULTILINESTRING ((14.2255559643784 12.535310492623, 14.22545716 12.53525329, 14.2255681722437 12.535142276674), (14.2253486194644 12.5354365712192, 14.22534511 12.53543537, 14.2253452112491 12.5354359050129), (14.2254322946943 12.5350009519167, 14.22534511 12.5350572, 14.2253176625444 12.5349920155292), (14.2251777257262 12.5353538098784, 14.22519804 12.53534433, 14.2251554943788 12.5353211232497), (14.2251707497098 12.5350789841119, 14.22517003 12.53512723, 14.2251395974926 12.5351247876065))

Here is the input linestring and point and the result of the query: