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!
Question 1: What are good substitutions/alternatives for Visual
  Foxpro? Would Python be able to carry out all the task Visual Foxpro
  can?  

I think you might want to look into Visual C# or Visual Basic using the .NET framework.
Python might be able to replace Visual FoxPro from what I hear.  

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?  

It might be justifiable but you might want to use the latest .NET frameworks to keep up with security patches or new features.
Visual FoxPro in 2018