Feature Request : Implement JWT Authentication for Backend with SQL Database

[SarveshAtawane]

Description:
We need to add user authentication to our backend API using JWT and store user credentials in a SQL database.

1. Set up a SQL database to store user information:

   • Create a 'users' table with fields for username, hashed password.

2. Implement user registration endpoint:

   • Create a /register route
   • Accept username and password in the request body
   • Hash the password before storing it in the database
   • Use SQL INSERT query to add new user to the 'users' table
   • Return appropriate success/error messages

3. Implement user login endpoint:

   • Create a /login route
   • Use SQL SELECT query to retrieve user credentials from the database
   • Verify provided password against the stored hashed password
   • Generate a JWT token upon successful authentication
   • Return the token in the response

4. Create JWT authentication middleware:

   • Implement a function to verify JWT tokens
   • Create a dependency that can be used to protect routes

5. Secure relevant API endpoints:

   • Apply the JWT authentication dependency to the /query route
   • Return appropriate error messages for unauthorized access attempts