Implement Station Search (by Name and Address)

[theodanel]

Summary

Create an endpoint to search stations based on name, street name, and city.

Details

Allow users to search for stations using specific text criteria (Name, Street, City) or by location, and return results enriched with real-time availability.

Subtasks

• Define the search endpoint (/search) and parameter (q).
• Implement the Name/Street/City Search logic using appropriate SQL filtering.
• Implement location-based search
• Ensure the results are sorted from nearest to furthest when searching by location.

Additional Notes / References

No response

Pre-Work Checklist

• No existing issue covers this work.