Is automated machine learning a dream? As I discover machine learning I see different interesting techniques such as:


*

*automatically tune algorithms with techniques such as grid search, 

*get more accurate results through the combination of different algorithms of the same "type", that's boosting,

*get more accurate results through the combination of different algorithms (but not the same type of algorithms), that's stacking, 

*and probably lots more I still have to discover...


My question is the following: there are all those pieces. But is it possible to put them together to make an algorithm that takes as input cleaned data and outputs good results by taking the best out of all techniques? (Of course it will probably be less efficient that a professional data scientist, but he will be better than me!) If yes, do you have sample codes or do you know frameworks that can do that?
EDIT : After some answers, it seems some narrowing has to be done.
Let's take an example, we have one column with categorical data, let's call it y and we want to predict it from numerical data X that is either dummies or real numerical data (height, temperature). We assume cleaning has been done previously. Are there existing algorithm that can take such data and output a prediction? (by testing multiple algorithms, tuning them, boosting, etc.) If yes, is it computationally efficient (are the calculations done in a reasonable time if we compare to normal algorithm), and do you have an example of code? 
 A: If you know beforehand what kind of data you will feed in ("these are monthly sales of CPGs, with prices and promotion markers, and I want a point forecast"), so you can tune your setup ahead of time, that will likely be possible and already done, see various "expert systems" for certain specific tasks.
If you are looking for something that can take any kind of data and do "something useful" with it ("ah, here I am supposed to recognize handwriting and output ZIP codes, and there I should do fraud detection, and this input file obviously is a credit scoring task"), no, I don't think that will happen in a long time.
Sorry for an opinion-based answer to what might well be closed as an opinion-based question.

EDIT to address the edited question:

we have one column with categorical data, let's call it $y$ and we want to predict it from numerical data $X$ that is either dummies or real numerical data

This sounds like something that Random Forests are actually pretty good at. Then again, a "general-purpose" algorithm like RFs will likely never beat an algorithm that was tuned to a particular type of $y$ known beforehand, e.g., handwritten digits, or credit default risks.
A: What you describe already exists to some extent, for example in AutoWEKA, and is being researrched actively (e.g. challenges like Chalearn's AutoML).
This is usually considered in the subfield of hyperparameter optimization. Software packages like Optunity, Hyperopt and ParamILS can be used to automatically optimize hyperparameters for a given approach and choose which approach happens to be the best. That said, such optimization problems are not trivial and usually it takes a long time to automatically obtain the best model (or close to it). 
You can find an example of using Optunity to automatically determine the best learning algorithm and optimize its hyperparameters at http://optunity.readthedocs.org/en/latest/notebooks/notebooks/sklearn-automated-classification.html
A: Advances in hyper parameter tuning and ensemble models are taking a lot of the 'art' out of model building. However, there are two important aspects of model building that hyper parameter tuning and ensembles don't deal with and will keep you from finding the best possible model.
First, certain types of algorithms are better at modeling certain types of data.  For example, if there are interactions between your variables, an additive model is not going to find them, but a decision tree will. Knowing how models behave on different dataset, and picking the right one, might require knowledge about the domain to find the best modeling algorithm. 
Second, feature engineering and feature extraction is the real 'art' to model building. Your question assumes that the dataset is already prepared. But what you should not assume is that the dataset is the best possible representation of what you are trying to model.  This is always and open question.  In many cases, where the data set is complex, you can engineer features all day long, but you risk throwing more and more noise into the algorithm. To know which features to add you must know which features make sense from a statistical perspective and which make sense from the perspective of the domain expert. 
For those two reasons, I conclude that no, you will not be able to find an algorithm that finds the best possible model automatically. This is also why I'm skeptical of software vendors pitching tools that will replace the need for data scientists.   
However, if you are narrowing your ambition to finding the best model from a fixed set of models, with optimal hyper parameters, where 'best' is defined as the highest predictive accuracy on a training set, then yes, this is possible.
Check out the caret package in R as an example of how to automatically tune models. caret uses grid search, which has flaws, and it only builds one model at a time. However, there are functions to compare models and convenient wrappers for a long list of models from many different R packages.
A: Depends on who you ask.
I recently heard a talk by Scott Golder at Context Relevant. Their product is essentially a feature and model selection robot. The basic underlying model is logistic regression, but the system basically uses machine learning to figure out the right combination of feature selection, dimension reduction, regularization, etc. for generating accurate predictions. It was a very impressive talk, and the details are all very proprietary. Apparently their clients include major financial companies and the system can handle arbitrarily massive data sets.
At least a few people, then, seem to think automated data science is already here, at least for certain applications. And some of those people (Context Relevant's clients) are apparently paying through the nose for access to it.
A: No it's not a dream.  We've implemented this (the combination of all the techniques you mentioned, including stacked ensembles) in the H2O machine learning library.  You can read more about it and find code examples in R and Python here.
