sqlkata/querybuilder

Value Expressions

davisylvestre opened this issue · 2 comments

davisylvestre commented

I would like to know if it is possible to build the queries below.
I left an example in SQL Server and another in SQLite.
I'm not familiar with the other database drivers.
The records would come from a list List<T>

PS: sorry for any English mistakes, it's not my native language

SQLite

WITH emp_master (emp_id, first_name, last_name, salary) AS(
  VALUES (1,"Honey","Patel",10100),
         (2,"Shweta","Jariwala", 19300),
         (3,"Vinay","Jariwala", 35100)
)
SELECT *
  FROM emp_master;

SQL Server

SELECT *
  FROM (VALUES (1,"Honey","Patel",10100),
               (2,"Shweta","Jariwala", 19300),
               (3,"Vinay","Jariwala", 35100)) emp_master (emp_id, first_name, last_name, salary);