In our company some database administrators are still querying MS SQL Server DB with Visual Foxpro.
Eventhough I'm not a DB administrator, I reckon it's time to migrate those queries to a more recent DB management system.
Question 1:
What are good substitutions/alternatives for Visual Foxpro?
Would Python be able to carry out all the task Visual Foxpro can?
Question 2:
The administators still defend the use of this language, eventhough support stopped in 2007. Is it still justifiable to keep using Visual Foxpro in 2018?
Thank you for your help!
In our company some database administrators are still querying SQL Server database with Visual Foxpro.  

You need to find out if they are just manually querying the SQL Server data for reports or are they actually using a VFP Application (which itself queries the SQL Server data).  
If they are running a VFP Application, then to change, you (or they) will have to totally redesign and redevelop the application in the replacement language - depending on the complexity of the application - most often not an insignificant task.  
If you are considering changing to another language rather than just following someone's advice or their 'gut' feeling such as  

I reckon it's time to migrate those queries to a more recent database management system

You need to do a business analysis. At the very least you should ask the following questions.  

Is the current operation Business Critical to the operations?   
What is the REAL reason for changing?  
What advantages will be gained by changing?  
What will the timeline and budget look like to make the change?  
Is this software to be run in-house only or will it be run across the web?  

In regards to Question 2  
Sure VFP is a 'dated language', and its support from Microsoft is no longer available, but there is a VERY Active community of VFP developers who are available in various web forums who can offer far superior support to VFP questions than MS ever did.  
Those VFP developers are still using the language and plan to continue to do so for quite a while. So 'language support', by itself, seems like a moot issue.    
In regards to question 1  
There are a number of languages to change to. Some are rather simplistic and others are more full-featured.  
Again, if this is a VFP Application which is to be changed rather than just a few queries, then plan for an extensive effort no matter what language you change to.  
Also your answers to the Business Analysis questions may guide you towards one language over another.  
I do find it odd that you say  

We also observe a lot of time going to problem solving rather than improving the services

I have developed FP/VFP applications for 30+ years now (currently in addition to Android and VB.ASP) and have found that once developed and implemented these are very stable applications.  Sure there can be Network issues and data change issues which are problematic, but it is not the VFP software that is 'mis-behaving' - instead it is 'external' things which are causing the stable VFP application to no longer behave as expected.  
Although I will say that a poorly designed application (VFP or other) will be frequently problematic.  
Whichever way you go - good luck.
Visual FoxPro in 2018