By using dpylr package sum of multiple columns

Question

Using mtcars dataset

I want to sum the columns but not using other methods because other function does not work on SQL

reduce,row-wise, rowSums doesn't work for SQL tables

I want some like this

Answer 1

Basically here we are making an equation and evaluating it.

library("dplyr")

library(stringr)

#fetching varaible names and forming an equation

equation_<- paste0(collapse = "+",str_subset(colnames(mtcars),"[a-z]"))

#using mutate function parsing and evaluating the equation to the result

mtcars %>% mutate(Sum_Col=eval(parse(text=equation_)))