Can you create a column during SQL query connector?

[Chris1300]

I am doing a query to get data using the Azure Synapse Analytics SQL connector. The database is in Azure Synapse. My current query: 

SELECT TOP (100) [SESSION_REQUEST] ,[INSERT_TIME] ,[REQUEST_ID] ,[SESSION_ID] ,[COMMAND] FROM [abc].[SessionRequests]

I would also like to have a new column created that will do a RegEx on [COMMAND].

This is my RegEx code: [Ff][Rr][Oo][Mm]\s[\s]+

Does SQL query in PowerBI allow this type of query where you can create a new column during the query code? How can I do this? 

I have seen other posts about using R or Python Scripts to do the RegEx, but this is NOT an option for me. 

[Chris1300 · Accepted solution]

I ended up using the power query builtin function for splitting and extracting text columns. It involved multiple steps and different functions but got it close to using RegEx like.

[aj1973]

Hi @Chris1300 

You can use Power Query to add queries to your selected one and ultimately you can also use DAX.

[Shaurya]

Hi @Chris1300,

This link may provide you some information that you need:

https://learn.microsoft.com/en-us/power-query/power-query-folding

Mark this post as a solution if that works for you!