It may be that whomever told you that jupyter is just for teaching doesn't like or get jupyter. Answering an ad hoc question in a meeting with leaders? Just write some SQL in Sequel Ace (if mysql) or similar tool. Taking a POC ML model to production? Copy your jupyter notebook into VSCode and refactor as needed. Production-ready ML model? I generally use VSCode. So, the real question is what's the right tool for whatever you're doing? Exploratory data project or a POC ML model? I use Jupyter Lab for that. Or, if there is, it'll be trying to hard to be too many things. As you might imagine, there isn't one tool that works for all of these things.
In my experience, my work spans from meeting with leaders to help define data strategy, doing ad hoc analysis, building ML models (both for analytic purposes and for production purposes), designing RCTs, and building data pipelines. It felt like they wanted us to take a step backwards to using notebooks just because they had read that data scientists sometimes use Jupyter ( it has notebooks.
#Most common ide for r code
Meanwhile, the data science team was actually committing code to an ETL repo, doing code reviews, etc. My last company, the data engineering team was pushing the data science team to write data and ML pipelines in jupyter notebooks (and the DE team would build infrastructure to support deployment of notebooks to production). I think there are a lot of really odd notions out there of what data scientists do.